Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to Postgres migration open source tool - Mailing list pgsql-general

From akp geek
Subject Re: Oracle to Postgres migration open source tool
Date
Msg-id CACnhOfL-MuhhEwmesPc2XgWiwRidMQw9_KxLvCYp-LeD=P+JeQ@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to Postgres migration open source tool  (Lennin Caro <lennin.caro@yahoo.com>)
Responses Re: Oracle to Postgres migration open source tool
List pgsql-general
Tree view
Thank you all for the responses. All we have is just table migrations, no procedures, triggers involved. I will try to do the migration using ora2pg. I downloaded it, while installing it I am getting an error. Will try to resolve that and proceed

Writing /export/home/postgres/perl_5_10_0/lib/perl5/site_perl/5.10.0/sun4-solaris/auto/Ora2Pg/.packlist
sh install_all.sh
install_all.sh: test: argument expected
gmake: *** [install_all] Error 1


Thanks again

Regards


On Thu, Jul 7, 2011 at 11:51 AM, Lennin Caro <lennin.caro@yahoo.com> wrote:
--- On Thu, 7/7/11, Craig Ringer <craig@postnewspapers.com.au> wrote:

From: Craig Ringer <craig@postnewspapers.com.au>

Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
To: "akp geek" <akpgeek@gmail.com>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Date: Thursday, July 7, 2011, 2:02 PM

On 7/07/2011 9:55 PM, akp geek wrote:
> Hi all -
>
>                 Are there any open source tools available for migrating
> from oracle to postgres. We have 20 tables in oracles that we needed to
> get to postgres. Appreciate your help

One avenue you may wish to investigate is ETL tools like Talend. See Google.

EnterpriseDB offer an enhanced version of PostgreSQL with add-on Oracle compatibility features to ease porting. This might be worth looking into.

Numerous companies offer consulting services for PostgreSQL, some of which will cover Oracle migrations/conversions. See:
  http://www.postgresql.org/support/professional_support

As for specific oracle to PostgreSQL migration tools: Tried Google yet?

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

i have used ora2pg migrate oracle database to postgresql
http://pgfoundry.org/projects/ora2pg



pgsql-general by date:

Previous
From: Lennin Caro
Date:
Subject: Re: Oracle to Postgres migration open source tool
Next
From: Alexander Farber
Date:
Subject: Re: Trying to find miss and mister of the last month with highest rating