On May 2, 2013, at 10:38 AM, "McKinzie, Alan (Alan)" <alan...@avaya.com> wrote:
> I used ora2pg a couple years ago. I made a few minor changes to fit our > specific requirements, but it worked well for our migration to Postgresql. Ora2Pg is a good tool for one time migration. However, when we come to crucial production databases where we have least downtime window. Then replicating data from Oracle to PostgreSQL and later doing switchover to postgreSQL (new database) in short window, is the efficient way I have found and I have used xDB Replication most of time, since its easy to configure and provides GUI mode to monitor your replication etc. I did many migration from Oracle Production database to PostgreSQL. Getting long downtime window for Production is the main issue I have seen for crucial customer facing applications. Thanks & Regards, Vibhor Kumar Blogs:http://vibhork.blogspot.com http://vibhorkumar.wordpress.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
