Re: How best can a synchronisation be done between Oracle and MySQL
Remi,
I'm doing something similar at my work. We solved this issue through the use of Perl. With Perl DBI (Database Interface), you can connect to virtually any data sources and it is super fast - at least it has been for the things were doing - and it's platform indepentant (for the most part, anyway).
To make a Perl DBI connection, you will need the client for the database you are connecting to installed and the Perl DBD (Database Driver) installed. These DBD's can be installed directly from CPAN (www.cpan.org) or from ActiveState (www.activestate.org) if you are using the Windows Perl interpreter.
We investigates using scripts and java for handling the data moving, but Perl proved to be the best option for us. Perl was relatively easy to learn and there is a ton of information on the web to help you develop your program.
Hope this helped.
Craig...
Subject
Written By
Posted
Re: How best can a synchronisation be done between Oracle and MySQL
May 23, 2006 08:27AM
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.