Search Postgresql Archives

Re: Oracle to Postgres migration open source tool

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
--- On Thu, 7/7/11, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote:

From: Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx>

Subject: Re: Oracle to Postgres migration open source tool
To: "akp geek" <akpgeek@xxxxxxxxx>
Cc: "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx)
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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux