Re: Oracle to PostgreSQL transition?

[Michael Paquier <michael.paquier@xxxxxxxxx>]

On Thu, Apr 4, 2013 at 11:16 PM, Roy Anderson <roy.anderson@xxxxxxxxx> wrote:

Hey all,

We have a very robust Oracle and SQL Server presence at work but we're looking to farm out some of the load to PostgreSQL to limit costs. I'm curious if there are any DBAs out there who have gone down this route before. Any tips, tricks, failures, successes, etc.? I would just like to hear some first-hand commentary on this topic.

Here is a tool that can be used to migrate an Oracle DB into a Postgres DB:

https://github.com/darold/ora2pg

Hope it is useful.

--
Michael