From: Vibhor Kumar <vibhor.aim@gmail.com>
To: McKinzie, Alan (Alan) <alanmck@avaya.com>
Cc: Paul B. Anderson <paul.a@pnlassociates.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Migration from Oracle 11g to Postgresql
Date: Thu, 2 May 2013 10:49:15 -0400
Message-ID: <2CC51A0B-1ED6-475F-BB25-CFDB0D15DF80@gmail.com> (raw)
In-Reply-To: <E8D40D92FF4F29479EA59F839673E63E04EC4D@AZ-US1EXMB02.global.avaya.com>
References: <CANwDVowrLpzvgizkz+ene1K21ttX3W_voqTVErt8vyDCnPyU6g@mail.gmail.com>
<C202FD88-E84A-4DB6-99CB-60B89A4AE1B5@gmail.com>
<CAP5xjbv8tncUfbx7o4ZCtQNa_RyYdOfAhJfFGM+94HZgV9XSWA@mail.gmail.com>
<5182787F.1070501@pnlassociates.com>
<E8D40D92FF4F29479EA59F839673E63E04EC4D@AZ-US1EXMB02.global.avaya.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On May 2, 2013, at 10:38 AM, "McKinzie, Alan (Alan)" <alanmck@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.comhttp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, alanmck@avaya.com, paul.a@pnlassociates.com
Subject: Re: Migration from Oracle 11g to Postgresql
In-Reply-To: <2CC51A0B-1ED6-475F-BB25-CFDB0D15DF80@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox