An option would be a log reader program that uses Oracle log miner to only show commited transactions from the redo logs. You could then replay the SQL that is being executed on the oracle box on the mysql server as long as the tables are defined the same.
9i has an enhanced log miner that can be used to read 8i redo logs as well, so you might want to use the newer 9i client if you go this way. Updates to the oracle database could be processed the same way using the mysql binary log as long as no mysql extensions were used like inserting multiple rows with a single insert statement. --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
