Rename a migration or synchronization object

This topic describes how to rename a migration or synchronization object in OceanBase Migration Service (OMS).

Application scenarios

By default, a migrated or synchronized object, such as a database or table, has the same name at the source and destination. OMS allows you to rename a migrated or synchronized object at the destination to implement mappings of database names and table names between the source and destination. The renaming feature usually applies to multi-table aggregation scenarios and scenarios where the object names in the test and production environments are inconsistent.

Limitations

• OMS allows you to rename a migration or synchronization object only in the step of selecting migration or synchronization objects when you configure a data migration or synchronization project.

• After a data migration or synchronization project is started, do not rename migration or synchronization objects. Otherwise, the project may fail.

• In data synchronization scenarios, you can rename a specified object only when you synchronize data from an ODP logical table to a physical table of a MySQL tenant of OceanBase Database, or from an IDB logical table to a MySQL tenant of OceanBase Database.

Rename a specified object

When you select migration or synchronization objects by using the Specify Objects option, you can perform the following operations to rename a specified object:

1. Configure the data migration or synchronization project to the Select Migration Objects or Select Synchronization Objects step.

   For more information, see the documentation of data migration or data synchronization projects of the corresponding type.

2. Select migration or synchronization objects by using the Specify Objects option. Then, in the Destination Object list in the Specify Migration Scope or Specify Synchronization Scope section, hover over the target table object and click Rename.

3. Enter the new name of the object at the destination.

4. Click OK. Then, you can view the new name of the object.

5. Complete subsequent project settings as prompted.

Rename an object based on rule matching

When you select migration objects by using the Match Rules option, you can perform the following operations to rename an object:

1. Configure a data migration project to the Select Migration Objects step.

   For more information, see the documentation of data migration projects of the corresponding type.

2. Select migration objects by using the Match Rules option. Then, enter the renaming equation in the Object Migration Rule field in the Specify Migration Scope section. In the Object Migration Rule field, you can use an equal sign (=) to clear the mapping between the source and destination and rename an object. For example, assume that a source database is named test and a source table is named test1. You can enter test.test1=a.b to rename the database as a and the table as b.

3. Click Verify.

4. After the verification succeeds, click Preview Object to view the new database name and table name.

5. Complete subsequent project settings as prompted.