MsSQL -> MySQL Sync
Posted on 2003-11-28
I have to synchronize two tables between a MsSQL and a MySQL database. The MsSQL is the master database and updates/inserts/deletes will only be made here.
I read that DTS might be a good choice for the synchronization.
My problem is that when I try to make a datapump from MsSQL to MySQL the “Enterprise Manager” crashes?? When defining the datapump it’s possible to define the source, but when I try to define the destination (MySQL) I get an error message “HRresult….”. sometimes if I’m lucky I get a chance to choose the destination table, but the Enterprise Manager can only find tablenames – NOT the fields of the table?? The strange thins is that the table names starts with “INFORMATION_SCHEMA”??
I’m using the MyOLEDB3 driver to connect to the MySQL database….. can that be the problem?