Replication from Informix to MySQL

Posted in 2006

Topics: Triggers, Constraints & Referential Integrity, Licensing & Editions

Jeff Filippi — Wed, 24 May 2006 21:29:27 — source: IIUG Forums & Mailing Lists

Is there any product out there that does replication from Informix to MySQL. There use to be a product Ominireplicator by Praxis that did trigger based replication before ER was even available, but I could not find any information on them. My client is looking to replicate from Informix to multiple MySQL servers parts of the data to each MySQL server (One way replication). They do not want to use ER because of license costs of Informix on all the other servers. Thanks, Jeff

↪ replying to Jeff Filippi

sergio@moredata.pt — Thu, 25 May 2006 09:03:27 — source: IIUG Forums & Mailing Lists

Hi. For what I know there is no such product. But even if there is no product, this can be easily made (in Informix > 9.X). It can be made a trigger and Java UDT generation that does this. If you need professional assistance e-mail me directly. Ségrio > Is there any product out there that does replication from Informix to > MySQL. > There use to be a product Ominireplicator by Praxis that did trigger based > replication before ER was even available, but I could not find any > information on them. > > My client is looking to replicate from Informix to multiple MySQL servers > parts of the data to each MySQL server (One way replication). They do not > want to use ER because of license costs of Informix on all the other > servers. > > Thanks, Jeff > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to sergio@moredata.pt

Richard Snoke — Thu, 25 May 2006 10:56:37 — source: IIUG Forums & Mailing Lists

Praxis was acquired by Progress Software a few years ago. From their web site (http://www.progress.com), it appears that Progress no longer sells (but still supports) Peer Direct. Cheers, "sergio@more...." <sergio@moredata.pt> Sent by: ids-bounces@iiug.org 05/25/2006 05:03 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: Replication from Informix to MySQL [6807] Hi. For what I know there is no such product. But even if there is no product, this can be easily made (in Informix > 9.X). It can be made a trigger and Java UDT generation that does this. If you need professional assistance e-mail me directly. Ségrio > Is there any product out there that does replication from Informix to > MySQL. > There use to be a product Ominireplicator by Praxis that did trigger based > replication before ER was even available, but I could not find any > information on them. > > My client is looking to replicate from Informix to multiple MySQL servers > parts of the data to each MySQL server (One way replication). They do not > want to use ER because of license costs of Informix on all the other > servers. > > Thanks, Jeff > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Richard Snoke

Jack Parker — Thu, 25 May 2006 11:03:34 — source: IIUG Forums & Mailing Lists

Golden Gate has a product which is database neutral and can do things like replication. j. > Is there any product out there that does replication from Informix to > MySQL. > There use to be a product Ominireplicator by Praxis that did trigger based > replication before ER was even available, but I could not find any > information on them. > > My client is looking to replicate from Informix to multiple MySQL servers > parts of the data to each MySQL server (One way replication). They do not > want to use ER because of license costs of Informix on all the other > servers. > > Thanks, Jeff > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > >