Re: Oracle to Postgres migration open source tool

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to Postgres migration open source tool
Date: 2011-07-07 14:02:40
Message-ID: 4E15BC80.8050401@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message casp 2011-07-07 14:05:32 Re: Oracle to Postgres migration open source tool
Previous Message David Hartveld 2011-07-07 13:59:08 Re: Streaming replication on 9.1-beta2 after pg_restore is very slow