All Products
Search
Document Center

Data Transmission Service:Check whether the name of an object in the destination database is the same as that of an object to be migrated

Last Updated:Aug 30, 2023

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.

  1. Login DTS console in the left-side navigation pane, find the target migration task, and then click Edit Task.

  2. In the source and destination databases page, click the authorize the whitelist and go to the next step..

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

  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.