Re: 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>:

>
> On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar <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
>