Scenario
An error occurred while DTS was synchronizing incremental data based on a task that contains incremental data migration or synchronization. The error log information contains "Table xxx already exists".
Keywords
Table xxx already exists
Possible Causes
The destination database already contains a table that has the same name as the object to be synchronized. As a result, an error occurred while DTS was synchronizing the table creation DDL statement from the source database to the destination database.
Solutions
Pause the task.
Check the table with the same name in the destination database to determine whether it was created for another workload and evaluate whether it can be deleted (depending on whether the table contains data).
If the table can be deleted, delete it and then restart the task.
If the table cannot be deleted because it already contains data, we recommend that you recreate a synchronization task and specify another database as the destination database.