After an object, such as a database or table, is synchronized from the source instance to the destination instance, the name of the object remains unchanged. You can use the object name mapping feature provided by DTS to specify a different name for the object in the destination instance.
Notes
You can perform this operation only when a data synchronization task is configured and the current process is Select Objects to Synchronize.
Procedure
- On the Select Objects to Synchronize page, move the required objects to the Selected section, move the pointer over a database or table, and then click Edit.
Note Different database types support different objects. If Edit appears when you move the pointer over the target object, the operation is supported.
- In the dialog box that appears, specify a name for the object in the destination instance.
- Database name mapping
In the Edit Database Name dialog box that appears, enter the database name that you want to use in the destination instance.
- Table name mapping
In the Edit Table dialog box that appears, enter the table name that you want to use in the destination instance.
- Column name mapping
In the Edit Table dialog box that appears, enter a new name for each column.
Note In this step, you can deselect columns that do not need to be synchronized.
- Database name mapping
- Click OK.
- Configure other parameters that are required for the data synchronization task.