Hi,
> I have a project which need to synch our mysql db with external
> Oracle DB.
> It requires that anytime DB admin modifies their Oracle DB, the
> change should be synched remotely with our DB in mysql. To make
> thing easy, we could use the same table structure on both end.
just a quick idea that popped into my mind (i'm not completely sure
about Oracle's possibilities on this, but it might be worth to give
a look at):
in Oracle, you can set up triggers for tables. you can try to make
a trigger that on table update writes the corresponding SQL clause
to update the remote table in a file. then, write a little crontab
script that checks for the files created by Oracle trigger, and
copies them over to the remote MySQL server (via scp for example).
on the MySQL server machine, create another crontab script that
checks for the existence of these files, and if they exist, runs
"mysql -uuser -ppassword dbname < sqlfilename" to import the changes.
just my .02 :)
Rgds,
Tfr
--==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
