By default, synchronized objects such as databases and tables keep their original names in the destination instance. Use the object name mapping feature of DTS to rename them.
Limits
Object name mapping is available only in the Select Object to Be Synchronized step when you configure a data synchronization task.
Note Do not rename objects after a data synchronization task starts. This may cause the task to fail.
Procedure
- In the Select Object to Be Synchronized step, move the objects to synchronize to the Selected Objects section. Hover over the database or table to rename, and click Edit. Note Supported object types vary by database type. If the Edit button appears when you hover over an object, that object supports name mapping.
- In the dialog box, enter a new name for the object.
- Database name mapping
In the Edit Database Name dialog box, enter a new name for the database.
- Table name mapping
In the Edit Table dialog box, enter a new name for the table.
- Column name mapping
In the Edit Table dialog box, enter a new name for each column to rename.
Note To exclude columns from synchronization, clear their checkboxes.
- Database name mapping
- Click OK.
- Complete the remaining task configuration as prompted.