Re: Oracle to Postgres migration open source tool

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(dot)caro(at)yahoo(dot)com> wrote:

> --- On *Thu, 7/7/11, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>* wrote:
>
>
> From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
>
> Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
> To: "akp geek" <akpgeek(at)gmail(dot)com>
> Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org<http://mc/compose?to=pgsql-general(at)postgresql(dot)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
>
>
>