Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Question Unanswered: Informix -> Mysql synchronization


    How is it possible to synchronize two databases Informix -> Mysql?
    Database contains something about 10 tables and two of them have ~100.000 records, synchronization interval should be 10minutes.

    Is there any tool that could detect changes and convert them to SQL92 and send those changes to mysql?

    Or maybe is it possible to use triggers to solve the problem?

    Thank you

  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    short answer , NO...

    But, if you buy the Informix Gateway you can access the mysql from Informix and maybe use triggers (i don't know the limits of IDS Gateway)
    IBM - Informix Enterprise Gateway Manager - Add-on Overview

    I don't know if on mysql you can access Informix with ODBC (my guess is yes, you can).

    On version 11.50 of Informix have a new feature called , Change Data Capture , what is a interface to capture information on-line on Informix, or something like that. I don't study about it yet... but to do this you probably will need coding in C .
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts