Postgres Pro
Downloads
Home   >   mailing lists

Thread: [ADMIN] Replication Between heterogeneous Databases

[ADMIN] Replication Between heterogeneous Databases

From
Panneer Selvam
Date:
Dear All,

We would like to know about the replication mechanism or product available & supported for replicating data between Heterogeneous systems - most preferably between Oracle -> PostgreSQL.

Regards,
Panneerselvam D




Re: [ADMIN] Replication Between heterogeneous Databases

From
"Smith, Tony"
Date:
Hi There

I recommend SymmetricDS, have used it for quite a few years now.

There are other products around, but this one proved to be reliable and pretty straight forward to use.

Cheers

Tony
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] on behalf of Panneer Selvam [panneerselvamrmd@gmail.com]
Sent: 23 March 2017 11:09
To: pgsql-admin-owner@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: [ADMIN] Replication Between heterogeneous Databases

Dear All,

We would like to know about the replication mechanism or product available & supported for replicating data between Heterogeneous systems - most preferably between Oracle -> PostgreSQL.

Regards,
Panneerselvam D







___________________________________________________

This email is intended for the named recipient. The information contained
in it is confidential. You should not copy it for any purposes nor
disclose its contents to any other party. If you received this email
in error, please notify the sender immediately via email and delete
it from your computer.

Any views or opinions presented are solely those of the author and do not
necessarily represent those of the company.

PCI Compliancy: Please note, we do not send or wish to receive banking,
credit or debit card information by email or any other form of
communication.

Order on-line at
B2C http://www.cromwell.co.uk
B2B http://www.cromwell-industrial.co.uk

Cromwell Tools Limited, PO Box 14, 65 Chartwell Drive
Wigston, Leicester LE18 1AT. Tel 0116 2888000
Registered in England and Wales, Reg No 00986161
VAT GB 115 5713 87 900
__________________________________________________

Re: [ADMIN] Replication Between heterogeneous Databases

From
Alex Balashov
Date:
That would not be described by the term "replication" so much as ETL.

On Thu, Mar 23, 2017 at 04:39:58PM +0530, Panneer Selvam wrote:

> Dear All,
>
> We would like to know about the replication mechanism or product available
> & supported for replicating data between Heterogeneous systems - most
> preferably between Oracle -> PostgreSQL.
>
> Regards,
> Panneerselvam D

--
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/

Re: [ADMIN] Replication Between heterogeneous Databases

From
Samed YILDIRIM
Date:
Hi Panneer,
 
Take a look xDB Replication Server and SymmetricDS.
 
Best regards.


İyi çalışmalar.
Samed YILDIRIM



23.03.2017, 14:11, "Panneer Selvam" <panneerselvamrmd@gmail.com>:
Dear All,

We would like to know about the replication mechanism or product available & supported for replicating data between Heterogeneous systems - most preferably between Oracle -> PostgreSQL.

Regards,
Panneerselvam D




Re: [ADMIN] Replication Between heterogeneous Databases

From
Mark Kirkwood
Date:
Amazon has DMS (Data Migration Services) which will do this. Obviously
(from the name) it is targeted at migrating data, but it does have the
ability to replicate ongoing changes (I'm looking at using this for a
migration Oracle to Postgres).

regards

Mark

On 24/03/17 00:09, Panneer Selvam wrote:
> Dear All,
>
> We would like to know about the replication mechanism or product available
> & supported for replicating data between Heterogeneous systems - most
> preferably between Oracle -> PostgreSQL.
>
> Regards,
> Panneerselvam D
>