On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote: > Hello, > > I found a question about Oracle 2 MySQL replication in the > archive on Sep. 2001 but no mention since? > > We have a department using Oracle 8.1.7 and I'm running MySQL > 4.0 and neither of us wants to change :-) > > I could call a Perl, C++ or Java program from cron to periodically > update the MySQL instance from Oracle but was hoping to use a > trigger/stored procedure to initiate the update so it seems more > real time. Does this seem possible? > > Of course it may turn out non-trivial to write the synchronization > code so I'll take suggestions on that front also.
Golden Gate Software makes a product that does this. I'd have a look at what they offer. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
