MySQL Forums
Forum List  »  IBM DB2

Re: IBM DB2 / MYSQL Replication
Posted by: Dmitry Tolpeko
Date: January 20, 2005 02:49PM

Hello Andreas,

a) First, I recommend you to try IBM DataPropagator especially if you already have got it. It must work.

Since you need to replicate data from DB2 to MySQL, DataPropagator (CAPTURE program) will read DB2 transaction log and populate replication tables on DB2 AS/400.

Then DataPropagator's APPLY program will read these tables, and replicate data to MySQL using SQL INSERT statements.

As you see, all is very simple. For DataPropagator, the source database is very important , target may be any SQL compatible database, I think.

Give it a try! Good luck :)

b) DataPropagator is very powerful tool, but due to cost reasons, you may choose more simple solutions.

You can just export data from DB2 and reload them to MySQL. Existing data transfer tools can automate this work. As I said before MySQL LOAD command allows you transfer updates only (our tool SQLWays uses this feature e.g.)

It may be effective if you do not work with very large databases. What do you think?

Best regards, Dmitry Tolpeko
SQLWays - Data, Schema, Procedures conversion tool for various databases
http://www.ispirer.com

Options: ReplyQuote


Subject
Views
Written By
Posted
12441
January 19, 2005 03:50AM
5780
January 19, 2005 02:14PM
5468
January 20, 2005 05:27AM
5390
January 19, 2005 04:17PM
6000
January 20, 2005 05:24AM
Re: IBM DB2 / MYSQL Replication
7828
January 20, 2005 02:49PM
7429
April 13, 2005 03:11AM
5069
April 20, 2005 08:20AM
5933
June 24, 2005 05:04PM
5007
June 24, 2005 07:44PM
12640
January 24, 2006 09:12PM
5461
January 24, 2006 09:20PM
5026
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.