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.c...@yahoo.com> wrote: > --- On *Thu, 7/7/11, Craig Ringer <cr...@postnewspapers.com.au>* wrote: > > > From: Craig Ringer <cr...@postnewspapers.com.au> > > Subject: Re: [GENERAL] Oracle to Postgres migration open source tool > To: "akp geek" <akpg...@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<http://mc/compose?to=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 > > >