Re: Oracle to PostgreSQL transition?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Roy Anderson <roy(dot)anderson(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to PostgreSQL transition?
Date: 2013-04-05 07:31:31
Message-ID: CAB7nPqSFXQdELtBGRzBhq7FfhPBeX8bT-3e=x0asVACpeYkcfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 4, 2013 at 11:16 PM, Roy Anderson <roy(dot)anderson(at)gmail(dot)com>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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2013-04-05 08:45:10 Re: OID of type by name.
Previous Message Szymon Guz 2013-04-05 07:12:13 Re: Oracle to PostgreSQL transition?