Hello,

Does anyone knows how to avoid data duplication when exporting a table from MSSQL to MySQL or to update only the rows that had change some values?

I used DTS from MSSQL with myodbc but I encountered the problem with data duplication. I thought that I have to write a procedure that first empty the tables from MySQL and then recreate it with the values from MSSQL database, but I don't know how.

Many thanks for any suggestion

In the DTS gui, add a database connection to your MYSQL database...then add a custom query:

DELETE FROM table_name

Or modify your scheduled job in the SQL Enterprise Manager and add a step to delete the data in your MySQL database table.
========================================
Buh Bye!

Cheers,
Me