OceanBase Migration Service (OMS) Community Edition allows you to download the object settings of data synchronization projects and supports automatic configuration and verification of object settings based on imported CSV files. This allows you to save project settings and configure multiple synchronization projects at a time.
Download the settings of synchronization objects
Log on to the OMS Community Edition console.
In the left-side navigation pane, click Data Synchronization .
On the Data Synchronization page, click the name of the project whose object settings you want to download.
On the details page of the project, click the More icon in the upper-right corner, and then click Download Project Configuration .
Import the settings of synchronization objects
OMS Community Edition allows you to rename databases and tables and set row filter conditions, filter columns, and sharding columns by importing CSV files. You can download a template CSV file, modify it as needed, and then import it.
Notice:
If you edit the object information in an Excel file, separate the columns with commas (,), save the file as a CSV file, and then import the CSV file.
The imported CSV file must contain the following columns: source database name, source table name, topic name, filter columns (separated with semicolons), column mapping, sharding columns (separated with semicolons), and row filter conditions.
Log on to the OMS Community Edition console.
In the left-side navigation pane, click Data Synchronization.
On the Data Synchronization page, click Create Synchronization Project in the upper-right corner.
Create a synchronization project based on your business needs. In the list on the right of the Select Synchronization Objects page, click Import Objects in the upper-right corner.
The specific procedure of creating a data synchronization project depends on the source and destination nodes you select. For more information, see Create a data synchronization project.
In the Import Synchronization Objects dialog box, click Import CSV in the message and select a local CSV file to import it.
You can also click CSV Template in the message to download the template. Then, configure the settings in the template as needed and click Import CSV to import the synchronization objects.
After you import the objects, click Validate.
After the validation succeeds, click OK.