Solution

To ensure successful data migration, DTS checks whether the name of an object in the destination database is the same as that of an object to be migrated during PreCheck. However, DTS fails the PreCheck.

 

Causes

An object with the same name as the object to be migrated exists in the destination database.

 

Solution

You can choose any of the following methods to fix this issue based on your business needs.

 

Method 1: Use Database, table, and column mappings

Map the objects to be migrated to objects with different names in the destination database by using the object name mapping feature.

  1. Login DTS console in the left-side navigation pane, find the target migration task, and then click modify task configurations.
    p47488.png
  2. In the source and destination databases page, click the authorize the whitelist and go to the next step..
  3. Map the objects to be migrated that have the same name as the objects to be migrated to another object in the destination database. For more information, see database, table, and column mappings. Click pre-Check and start.

 

Method 2: adjust the objects that have the same name in the target database

Log on to the destination database, and rename or delete the objects that have identical names with the objects to be migrated.

 

Method 3: remove the objects that have the same names as the objects to be migrated

Modify the task configurations to remove the objects that have identical names with those in the destination database.

  1. Login DTS console in the left-side navigation pane, find the target migration task, and then click modify task configurations.
  2. In the source and destination databases page, click the authorize the whitelist and go to the next step..
  3. Select the object that has the same name, remove the object, and click pre-Check and start.

 

Application scope

  • Data Transmission Service (DTS)