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
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