This topic describes how to use the feature that allows you to rename database and table objects during migration, synchronization, or validation in OceanBase Migration Service (OMS).
Scenarios
By default, the names of objects to be migrated, synchronized, or verified, such as databases and tables, are the same in the source and target. You can use the object renaming feature provided by OMS to set the names of the objects in the target. This way, you can map the database and table names between the source and target. This feature is often used in scenarios where the naming conventions in test environments differ from those in production environments, or when aggregating data from multiple tables.
Note
The multi-table aggregation feature is mainly used to synchronize data from tables across databases managed by DRDS or MyCat to the same table in the target.
Limitations
OMS allows you to rename objects only when you are configuring the selection of objects to be migrated, synchronized, or verified in the task.
Do not rename objects after a data migration, synchronization, or validation task has been started. Otherwise, the task may fail.
For a data synchronization task, you can specify to rename only the logical database and table names of objects when you synchronize data from an IDB to an OceanBase Database in MySQL compatible mode.
OMS does not support renaming views.
When you migrate data from an Oracle database to an OceanBase Database in Oracle compatible mode, you cannot rename PL objects such as functions and stored procedures.
Rename objects
To rename an object, you need to complete the following steps:
Configure the data migration, data synchronization, or data validation task to the Select Migration Objects or Select Synchronization Objects step, or the Validation Objects step.
For more information, see Data Migration, Data Synchronization, or Data Validation.
After you select an object to be migrated, synchronized, or verified in the Specify Objects step, hover the pointer over the target table object in the Target Object(s) list, and click the Rename icon that appears.
Enter a new name in the text box.
Click ✅.
Complete subsequent task configuration as prompted.
Rename matching rules
When you select a migration object by Match by Rule, you can rename the object.
Notice
Only data migration tasks support the renaming of matching rules.
After you rename a migration object on the left, you cannot rename it on the right. The settings such as row filter conditions will not change after the renaming.
Configure the data migration task to the Select Migration Objects step.
For more information, see the documentation of the corresponding data migration task.
After you select a migration object by Match by Rule, enter the new name of the migration object in the Object Migration Rules field. You can use the equal sign (=) to clear the mapping between the source and target objects in the Object Migration Rules field and rename them. For example, if the name of the source database is
testand the name of the source table istest1, you can entertest.test1=a.bto change the name of the source database toaand the name of the source table tob.Click Verify.
After the validation succeeds, click Preview Objects to view the new name of the database and table.
Complete subsequent task configuration as prompted.