Way to sync Oracle > MySQL

[Bruno Lavoie]

Hello,

i will have to replicate data from a Oracle Master Database to a local MySQL application specific database. The number of tables are from 20 - 30.

Is there a way to sync the oracle tables to mysql ones? all these tables have the same defenition. I have todo is to sync it everynight (or on demand), it's not important to be highly up to date.

the Oracle tables are read only, this imply that i have only to import new records, changes, update, deleted rows from Oracle to MySQL! Main sync operation will be : new record insert, record info change (update rows from oracle to mysql), number of deleted rows will be less important than insert/update!
primary keys of tables are not changing (very rarely, on a few tables)

any existing scripts? i searched a bit without success! i'm looking it to be in perl (preferably)

or suggested algorithm? i have some ideas like to calculate a md5 for each rows and comparing that like:

$table1{key} => md5(..fields...) == $table2{key} => md5(..fields...)

the pitfall of this method is expensive to the used cpu time! i can concatenatte all the fields to check rather than compute md5. On concatenation i need all the table and all information in $table1{key} and $table2{key} and ---> high memory consumation..... bad! some tables have a count of 500000 to 10000000 records.

not clear? any questions? just ask!
thanks a lot
Bruno