MySQL Forums
Forum List  »  IBM DB2

Re: IBM DB2 / MYSQL Replication
Posted by: Dmitry Tolpeko
Date: January 19, 2005 04:17PM

Hi Andreas,

Could you please clarify your requirements for replication? Do you need a bi-directional, synchonized replication? Hope not :) Or you probably just need to transfer data to MySQL daily.

DataPropagator can work with non-IBM databases, but it requires support for triggers since it uses them to catch updates.

MySQL offers a great feature in the LOAD DATA INFILE command - REPLACE option.

You can export data from DB2 and load only new/modified records to MySQL using this option.

But first please tell us your requirements.


Best regards, Dmitry Tolpeko
SQLWays - Data, Schema transfer tool for Oracle, DB2, SQL Server, Sybase, Informix and MySQL
http://www.ispirer.com

Options: ReplyQuote


Subject
Views
Written By
Posted
12390
January 19, 2005 03:50AM
5761
January 19, 2005 02:14PM
5442
January 20, 2005 05:27AM
Re: IBM DB2 / MYSQL Replication
5362
January 19, 2005 04:17PM
5979
January 20, 2005 05:24AM
7801
January 20, 2005 02:49PM
7407
April 13, 2005 03:11AM
5047
April 20, 2005 08:20AM
5905
June 24, 2005 05:04PM
4984
June 24, 2005 07:44PM
12591
January 24, 2006 09:12PM
5432
January 24, 2006 09:20PM
5000
August 02, 2005 06:45AM


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.