Problem Description
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.
Login DTS console in the left-side navigation pane, find the target migration task, and then click Edit Task.
In the source and destination databases page, click the authorize the whitelist and go to the next step..
Map the to-be-migrated object that has the same name as an object in the destination database to another object in the destination database. For more information, see Object name mapping. 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 to-be-migrated object that has the same name as an object in the destination database
Modify the task configurations to remove the objects that have identical names with those in the destination database.
Login DTS console in the left-side navigation pane, find the target migration task, and then click modify task configurations.
In the source and destination databases page, click the authorize the whitelist and go to the next step..
Select the object that has the same name, remove the object, and click pre-Check and start.