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 Configure Task Objects and Advanced Settings 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
Configure Task Objects and Advanced Settings
step, move the objects to synchronize to the
Selected Objects
section. Right-click the database or table to rename.
Note Supported object types vary by database type. If the Edit button appears when you hover over an object, that object supports name mapping.Note If the source and destination databases are self-managed MySQL, RDS MySQL, or PolarDB MySQL, DDL and DML statement filtering is supported when you perform database or table name mapping. You can select the DDL or DML statements to synchronize based on your business requirements.
- If the statements selected for database name mapping and table name mapping are different, the statements selected for table name mapping prevail.
-
In the dialog box, enter a new name for the object.
-
Database or Schema 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.
You can exclude columns from synchronization by clearing their checkboxes.
Important You must clear the Full Table Synchronization checkbox before you can perform this operation.
-
Database or Schema name mapping
- Click OK.
- Complete the remaining task configuration as prompted.