Re: Oracle to PostgreSQL replication - Mailing list pgsql-general

From Serge Fonville
Subject Re: Oracle to PostgreSQL replication
Date
Msg-id CAOAS_+K8Wc0m2OqRk+--rnhYM6JPvNBQTdT0mRxYo64+_vv+bQ@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to PostgreSQL replication  (Geoff Montee <geoff.montee@gmail.com>)
Responses Re: Oracle to PostgreSQL replication
Re: Oracle to PostgreSQL replication
List pgsql-general
Hi,

I need to setup a replication process for continuously replicating changes happening in an Oracle Database to a PostgreSQL database.

My Oracle Database is version 11.2 and setup as a cluster with RAC
My Postgres database version is 9.2

Oracle Database is running in Solaris and PostgreSQL is running on RHEL.

Is there any commercial or open source tool available to achieve this?

How about EnterpriseDB XDB replication?

Kind regards/met vriendelijke groet,


2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com>:

On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:
Hi,


I need to setup a replication process for continuously replicating changes happening in an Oracle Database to a PostgreSQL database.


My Oracle Database is version 11.2 and setup as a cluster with RAC
My Postgres database version is 9.2

Oracle Database is running in Solaris and PostgreSQL is running on RHEL.

Is there any commercial or open source tool available to achieve this? 



Continuent's Tungsten Replicator apparently offers Oracle to MySQL replication. There's a wiki page that suggests PostgreSQL support was in development at one time. I'm not sure how far they got, or if they are still working on it.



Geoff Montee

pgsql-general by date:

Previous
From: Geoff Montee
Date:
Subject: Re: Oracle to PostgreSQL replication
Next
From: Sim Zacks
Date:
Subject: Re: Crosstab function