Re: Oracle to PostgreSQL replication

We use symmetricDS for this. Works pretty well.

http://www.symmetricds.org/

From: Serge Fonville <serge(dot)fonville(at)gmail(dot)com<mailto:serge(dot)fonville(at)gmail(dot)com>>
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee <geoff(dot)montee(at)gmail(dot)com<mailto:geoff(dot)montee(at)gmail(dot)com>>
Cc: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com<mailto:sameer(dot)kumar(at)ashnik(dot)com>>, PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>>
Subject: Re: [GENERAL] Oracle to PostgreSQL replication

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<http://www.enterprisedb.com/products-services-training/products/complementary-enterprisedb-products/xdb-replication-server>?

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff(dot)montee(at)gmail(dot)com<mailto:geoff(dot)montee(at)gmail(dot)com>>:

On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com<mailto:sameer(dot)kumar(at)ashnik(dot)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.

http://www.continuent.com/solutions/replication

https://wiki.postgresql.org/wiki/Tungsten

Geoff Montee