Data Transmission Service (DTS) allows you to configure name mappings between source and target columns, tables, or databases that have different names. You can define one-to-one mappings for individual objects for initial schema synchronization.

Procedure

Note You can perform this operation only in the Select Objects to Synchronize step of creating a data synchronization task. If you change the name mapping after the data synchronization task has already started, the synchronization task may fail.
  1. On the Select Objects to Synchronize page, move the required objects to the Selected list, 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.
    Click Edit
  2. In the dialog box that appears, specify a name for the object in the target instance.
    • Database name mapping

      In the Edit Database Name dialog box, enter the database name that you want to use in the target instance.

      Enter the database name
    • Table name mapping

      In the Edit Table dialog box, enter the table name that you want to use in the target instance.

      Enter the table name
    • Column name mapping

      In the Edit Table dialog box, enter a new name for each column that you want to rename.

      Specify column names
      Note In this step, you can deselect columns that do not need to be replicated.
  3. Click OK.
  4. Complete the other configurations and continue to create a task.