pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication Between heterogeneous Databases
5+ messages / 5 participants
[nested] [flat]
* Replication Between heterogeneous Databases
@ 2017-03-23 11:09 Panneer Selvam <panneerselvamrmd@gmail.com>
2017-03-23 11:24 ` Re: Replication Between heterogeneous Databases Smith, Tony <tony.smith@cromwell.co.uk>
2017-03-23 11:30 ` Re: Replication Between heterogeneous Databases Alex Balashov <abalashov@evaristesys.com>
2017-03-23 11:40 ` Re: Replication Between heterogeneous Databases Samed YILDIRIM <samed@reddoc.net>
2017-03-23 22:05 ` Re: Replication Between heterogeneous Databases Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 4 replies; 5+ messages in thread
From: Panneer Selvam @ 2017-03-23 11:09 UTC (permalink / raw)
To: pgsql-admin-owner@postgresql.org; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication Between heterogeneous Databases
2017-03-23 11:09 Replication Between heterogeneous Databases Panneer Selvam <panneerselvamrmd@gmail.com>
@ 2017-03-23 11:24 ` Smith, Tony <tony.smith@cromwell.co.uk>
3 siblings, 0 replies; 5+ messages in thread
From: Smith, Tony @ 2017-03-23 11:24 UTC (permalink / raw)
To: Panneer Selvam <panneerselvamrmd@gmail.com>; pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org>; +Cc: pgsql-admin
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.co.uk/ice
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
__________________________________________________
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication Between heterogeneous Databases
2017-03-23 11:09 Replication Between heterogeneous Databases Panneer Selvam <panneerselvamrmd@gmail.com>
@ 2017-03-23 11:30 ` Alex Balashov <abalashov@evaristesys.com>
3 siblings, 0 replies; 5+ messages in thread
From: Alex Balashov @ 2017-03-23 11:30 UTC (permalink / raw)
To: Panneer Selvam <panneerselvamrmd@gmail.com>; +Cc: pgsql-admin-owner@postgresql.org; pgsql-admin
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/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication Between heterogeneous Databases
2017-03-23 11:09 Replication Between heterogeneous Databases Panneer Selvam <panneerselvamrmd@gmail.com>
@ 2017-03-23 11:40 ` Samed YILDIRIM <samed@reddoc.net>
3 siblings, 0 replies; 5+ messages in thread
From: Samed YILDIRIM @ 2017-03-23 11:40 UTC (permalink / raw)
To: Panneer Selvam <panneerselvamrmd@gmail.com>; pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org>; +Cc: pgsql-admin
<div>Hi Panneer,</div><div> </div><div>Take a look xDB Replication Server and SymmetricDS.</div><div> </div><div>Best regards.</div><div><br /></div><div><br /></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div><br /></div><div>23.03.2017, 14:11, "Panneer Selvam" <panneerselvamrmd@gmail.com>:</div><blockquote type="cite"><div dir="ltr"><div style="font-family:trebuchet ms,sans-serif;">Dear All,</div><div style="font-family:trebuchet ms,sans-serif;"><br /></div><div style="font-family:trebuchet ms,sans-serif;">We would like to know about the replication mechanism or product available & supported for replicating data between Heterogeneous systems - most preferably between Oracle -> PostgreSQL.</div><div><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><br />Regards,<br /><div style="font-family:"trebuchet ms",sans-serif;">Panneerselvam D</div><br style="color:rgb(102,0,0);" /><br style="background-color:rgb(51,51,153);color:rgb(102,0,0);" /><br /><br /></div></div></div></div></div>
</div>
</blockquote>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Replication Between heterogeneous Databases
2017-03-23 11:09 Replication Between heterogeneous Databases Panneer Selvam <panneerselvamrmd@gmail.com>
@ 2017-03-23 22:05 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
3 siblings, 0 replies; 5+ messages in thread
From: Mark Kirkwood @ 2017-03-23 22:05 UTC (permalink / raw)
To: pgsql-admin
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
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-03-23 22:05 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-03-23 11:09 Replication Between heterogeneous Databases Panneer Selvam <panneerselvamrmd@gmail.com>
2017-03-23 11:24 ` Smith, Tony <tony.smith@cromwell.co.uk>
2017-03-23 11:30 ` Alex Balashov <abalashov@evaristesys.com>
2017-03-23 11:40 ` Samed YILDIRIM <samed@reddoc.net>
2017-03-23 22:05 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox