Re: Oracle to PostgreSQL Migration - Need Information

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Oracle to PostgreSQL Migration - Need Information
Date: 2015-07-08 20:20:44
Message-ID: 559D861C.5080203@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/8/2015 1:16 PM, dinesh kumar wrote:
> We recently done the similar migration for one of our customer. We
> used all opensource tools to achieve this migration process.
>
> We used Pentaho Data Integration tool for doing Online DB migration,
> which took minimal downtime with CDC{Change Data Capture} approach.
> Also, we used Ora2Pg tool to migrate the DB objects with some manual
> syntax modifications.
>

thats the easy part.

now what about the massive code base of pl/sql and triggers he mentioned ?

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CS DBA 2015-07-08 20:25:47 Re: Oracle to PostgreSQL Migration - Need Information
Previous Message dinesh kumar 2015-07-08 20:16:20 Re: Oracle to PostgreSQL Migration - Need Information