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_supportAs 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/
i have used ora2pg migrate oracle database to postgresql
http://pgfoundry.org/projects/ora2pg
|