Data Transmission Service:Object name mapping

Limits

• You can use the object name mapping feature only when a data migration task is configured and the current step is Configure Migration Types and Objects.
  Note Do not use the object name mapping feature after a data migration task is started. Otherwise, data may fail to be migrated.
• MongoDB supports only database name mapping and table name mapping.

Configure name mapping for a single database, table, and column

1. In the Configure Migration Types and Objects step, move the required objects to the Selected section, move the pointer over a database or table, and then click Edit.
   Important You can use the object name mapping feature only on objects that are supported by DTS.
   
2. In the dialog box that appears, specify a name for the object in the destination instance.
   Note

   • If the source and destination databases are user-created MySQL databases, ApsaraDB RDS for MySQL, or Apsara PolarDB for MySQL, you can specify the data definition language (DDL) and data manipulation language (DML) statements that you want to migrate.
   • If different statements are selected for database name mapping and table name mapping, the statements that are selected for table name mapping prevail.
   • Database name mapping

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

     
   • Table name mapping

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

     
   • Column name mapping

     In the Edit Table dialog box, enter a new name for each column.

     
     Note In this step, you can clear the columns that do not need to be migrated.
3. Click OK.
4. Configure other parameters that are required for the data migration task.

Configure name mapping for multiple tables and columns at a time

1. In the Configure Migration Types and Objects step, move the required objects to the Selected section.
   Important If the last selected object is a database, you cannot configure name mapping for tables or columns by specifying the Name batch change parameter.
2. In the lower part of the page, set the Name batch change parameter to Yes, and then click Advanced Settings.
3. In the Advanced Settings step, configure name mapping for tables and columns based on your needs.
   1. Select a range. In this example, select Section.
      Important If you select Section, you can search for specific databases and tables by entering their names.
   2. Select a rule from the drop-down list and configure the rule.
   3. Click Add Modification Rules.
      Important You can repeat steps i and ii to configure different rules for different tables.
   4. Click Preview to check whether the rules meet your expectations.
   5. On the Partial Preview tab, click the icon next to the database name in the Destination Database section, and then click Column Name Modification.
   6. Configure mapping rules for column names, and then click OK.
      Important

      • By default, a mapping rule applies to all column names. You can search for a specific column name and modify the mapping rule. To do this, you can enter the column name in the search box, and then click Search.
      • In the dialog box, you can specify conditions to filter data. For more information, see Use conditions to filter data.
   7. Click OK.
4. Click Precheck.
5. Configure other parameters that are required for the data migration task.