How best can a synchronisation be done between Oracle and MySQL
I would advise on how best can sync data between oracle8i and mySQL 3.23, 4.0.
I have oracle as a transaction DB and MySQL as a mirror/presentation DB but I need to constantly refresh the MySQL DB from oracle.
I am presently truncating data in all the MySQL table and creating inmsert statements for each record and excuting record after record but the process seems slow and the codes hard to maintain
Subject
Written By
Posted
How best can a synchronisation be done between Oracle and MySQL
May 05, 2006 08:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.