OceanBase Migration Service (OMS) allows you to download the settings of migration objects in a data migration task and supports automatic settings and verification of migration object settings based on imported CSV files. This feature helps you save time on task settings and allows for batch and quick task setup. The import feature is particularly useful for renaming and setting hundreds of objects at once.
Download object settings
After you migrate data to a target database by specifying migration objects, you can download the settings of the migration objects.
Log in to the OMS console.
In the left-side navigation pane, click Data Migration.
On the Data Migration page, click the name of the target data migration task.
On the details page of the task, click the More > Download Objects Settings.
Notice
If an object migration task is created by using the Matching Rules method, you cannot download the object settings.
Import object settings
OMS allows you to rename databases and tables and set row filter conditions by importing a CSV file. You can download the object settings of an existing task or a CSV file template, and then import the template as needed.
Notice
If you edit the information in an Excel file, separate the columns with commas (,), save the file as a CSV file, and then import the file.
The imported CSV file must contain the following columns: source database name, source object name, target database name, target object name, object type, and row filter condition.
Configure the data migration task to the Select Migration Objects step.
For more information, see the corresponding topic in Data Migration.
After you specify Specify Objects, click Import Objects in the upper-right corner of the Target Object(s) list.
Notice
You can import objects only after you specify Specify Objects.
In the dialog box that appears, click OK.
Click Import CSV File in the lower part of the Import Objects dialog box, and select a local CSV file to import it.
You can also click Download CSV Template File in the lower part of the dialog box to download the template. Then, configure the template as needed and click Import CSV File to import the migration objects.
The details of the CSV file are displayed on the page. You can edit the details as needed.
Note
You can edit the CSV file manually or by using an SQL script. You can also click Download Objects Settings on the details page to generate a CSV file.
You can enter names of databases or tables in the target database to map them to the source databases or tables.
Click Validate to check the source type and whether the row filter conditions are correct. If the verification succeeds, the number of verified tables and views is displayed.
Click OK to return to the Select Migration Objects page of the data migration task.
Complete subsequent task settings as prompted.