Data Transmission Service

Object to Be Migrated Already Exists in the Destination Database: xxx already exists

2023-10-31 02:20:55

Scenario

An error occurred while DTS was migrating structs based on a task that contains struct migration or synchronization. The following error message appears: xxx already exists.

Keywords

xxx already exists

Possible Causes

The destination database already contains an object that has the same name as the object to be migrated.

Solutions

  1. Pause the task.

  2. Delete the object with the same name from the destination database, and then restart the task.

  3. If this error persists, contact DTS technical support for troubleshooting.


_AK3_cBUQFMe