edit-icon download-icon

Object name mapping

Last Updated: Dec 21, 2017

When configuring a data migration task, you can use the object name mapping to map objects in source to target objects using different names. The migration object can be a database, table, or column. This document describes how to use the object name mapping feature for database name mapping, table name mapping, and column name mapping.

Database name mapping

Database name mapping can map the database name in the source to a different name in the target. This function can be called in Migration object and type configuration, during creation of a migration task.

Follow these steps to perform database name mapping:

  1. Select a database object in the Migration objects box, and add it to the Selected objects box. In this example, the database named dts in the source is mapped to dts_20170112 in the target.

    database

  2. Click Edit under the newly added database object to enter the Edit database page.

    Note: The Edit button appears when the mouse is hovered over a specific object in the Selected objects box.

    edit database

  3. Enter the name of the target database in the DatabaseName block, and then click OK.

    target name

Table name mapping

Table name mapping can map the table name in the source to a different name in the target. This function can be called in Migration object and type configuration, during creation of a migration task. It is used for specific table objects rather than database objects. Other structure objects (such as views, stored procedures, storage functions, and synonyms) can also use the same method to do name mapping.

Follow these steps to perform table name mapping:

  1. Select a table object to be migrated in the Migration objects box, and add it to the Selected objects box. In this example, the table named test in the source is mapped to test_01 in the target.

    table

  2. Click Edit under the newly added table object to enter the Edit table page.

    Note: The Edit button appears when the mouse is hovered over a specific object in the Selected objects box.

    edit table

  3. Enter the name of the target table in the Table name block, and then click OK.

    target name

Column name mapping

Column name mapping can map the column name in the source to a different name in the target. This function can be called in Migration object and type configuration, during creation of a migration task. It is used for column objects under specific tables rather than database objects.

Follow these steps to perform column name mapping:

  1. Select a table object to be migrated in the Migration objects box, and add it to the Selected objects box.

  2. Click Edit under the newly added table object containing the column object that uses a different name in the target.

    Note: The Edit button appears when the mouse is over a specific object in the Selected objects box.

  3. On the Edit table page, enter the column name for the target in the Column name block, and then click OK.

    column name

Thank you! We've received your feedback.