Data Transmission Service lets you download the configuration of migration objects from a data migration task. You can also import a CSV file to automatically configure and confirm these objects. This feature lets you save task configurations and quickly configure multiple objects at once. The import feature is useful for batch operations, such as renaming and configuring hundreds of objects.
Download object configurations
After you create a data migration task and specify the migration objects, you can download their configuration. This configuration includes source database names, source table names, destination database names, destination table names, column mappings, and row filter conditions.
Log on to the OceanBase Management Console .
In the navigation pane on the left, click Data Transmission Service > Data Migration.
On the Data Migration page, click the name of the target data migration task.
On the task details page, click ... > Download Object Configuration in the upper-right corner.
ImportantYou cannot download object configurations for data migration tasks that use the Matching Rules method to select migration objects.
Import object configurations
Data Transmission Service lets you import a CSV file to perform operations such as renaming databases and tables or setting row filter conditions. You can download the object configuration from an existing task or a CSV template, modify it as needed, and then import it.
If you edit the file in Excel, save it as a comma-separated values (CSV) file before you import it.
The imported CSV file must include the following columns: source database name, source table name, destination database name, destination table name, column mapping, and row filter conditions.
Log on to the OceanBase Management Console and purchase a data migration task.
For more information, see Purchase a data migration task.
On the Data Transmission Service > Data Migration page, click Configure for the data migration task that you purchased.
Follow the prompts to configure the data migration task. On the Select Migration Objects page, select Specify Objects. Then, in the Select Migration Scope list on the right, click Import Objects in the upper-right corner.
ImportantYou can import objects only when you select the Specify Objects method.
For more information about configuring a data migration task, see the documentation for your specific task type.
In the prompt that appears, click OK to open the Import Migration Objects dialog box.
At the bottom of the Import Migration Objects dialog box, click Import CSV File and select the CSV file from your local machine.
You can also click Download CSV Template File at the bottom of the dialog box. After you download and modify the template, click Import CSV File to import the migration objects.
The content of the CSV file appears in the interface. You can edit the content as needed.
NoteYou can generate the CSV file from a SQL script, by editing it manually, or using the Download Object Configuration feature on the task details page.
To map database or table names, enter names that are different from the source names.
Click Check Validity to verify that the source objects exist and that the row filter conditions are correct. If the check is successful, the system displays the number of tables and views that were successfully verified.
After the check is successful, click OK to return to the Select Migration Objects page.
Follow the prompts to complete the remaining task configuration steps.