Replication between Informix and MySQL

Posted in 2006

Topics: Performance & Tuning, Triggers, Constraints & Referential Integrity

MOUHAMADOU DIA — Tue, 25 Apr 2006 15:54:37 — source: IIUG Forums & Mailing Lists

Hello, I have two databases: one in Informix and one in MySQL. I want to replicate some tables from Informix to MySQL. Is there some tools that does it? I know that IDS_Replicator is able to do the job but it's based on triggers and shadow tables and could therefore impact the performance. I also think that octopus loader is able to replicate the information. Do someone have an idea?

↪ replying to MOUHAMADOU DIA

Andres Felipe — Tue, 25 Apr 2006 15:58:45 — source: IIUG Forums & Mailing Lists

I better to use a ETL tool when you are using different tools Andres F. 2006/4/25, MOUHAMADOU DIA <mdia@accovia.com>: > > Hello, > I have two databases: one in Informix and one in MySQL. > I want to replicate some tables from Informix to MySQL. > Is there some tools that does it? > I know that IDS_Replicator is able to do the job but it's based on triggers > and shadow tables and could therefore impact the performance. > I also think that octopus loader is able to replicate the information. > Do someone have an idea? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- ___________________ Andres F. AFTS ELECTRONICS & MUSICSHOP INC http://musicshop.mybesthost.com

↪ replying to MOUHAMADOU DIA

Andres Felipe — Tue, 25 Apr 2006 15:59:39 — source: IIUG Forums & Mailing Lists

Is better to use a ETL tool when you are using different databases 2006/4/25, Andres Felipe Troncoso <anfetro@gmail.com>: > I better to use a ETL tool when you are using different tools > > Andres F. > > > > 2006/4/25, MOUHAMADOU DIA <mdia@accovia.com>: > > > > Hello, > > I have two databases: one in Informix and one in MySQL. > > I want to replicate some tables from Informix to MySQL. > > Is there some tools that does it? > > I know that IDS_Replicator is able to do the job but it's based on triggers > > and shadow tables and could therefore impact the performance. > > I also think that octopus loader is able to replicate the information. > > Do someone have an idea? > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > -- > ___________________ > Andres F. > AFTS ELECTRONICS & MUSICSHOP INC > http://musicshop.mybesthost.com > -- ___________________ Andres F. AFTS ELECTRONICS & MUSICSHOP INC http://musicshop.mybesthost.com