On Wed, Jul 8, 2015 at 1:20 PM, John R Pierce <pie...@hogranch.com> wrote:
> 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 ? > > Yeah, we need to rewrite the business logic if there are any un-supported features like autonomous transactions, packages, nested procedures, e.t.c. Regards, Dinesh manojadinesh.blogspot.com > > -- > john r pierce, recycling bits in santa cruz > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >