Configure a DTS data migration node

Prerequisites

• The source and destination databases are one of the following types: MySQL, SQL Server, PostgreSQL, AnalyticDB for MySQL 2.0, AnalyticDB for MySQL 3.0, PolarDB for MySQL, or AnalyticDB for PostgreSQL.

• The source and destination databases are ApsaraDB RDS instances or databases connected over the internet.

• The source and destination databases are in the same region.

• The source and destination databases belong to the Alibaba Cloud account that is used to log on to Data Management (DMS).

Procedure

1. Log on to the DMS console V5.0.

2. In the top navigation bar, choose Data+AI > Data+AI > Task Orchestration.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose All Features > Data+AI > Data Development > Task Orchestration.

3. Click the name of the task flow that you want to manage to go to the details page of the task flow.

   Note

   To create a task flow, see Create a task flow.

4. Optional: You can click the icon to fold the basic configurations panel of the task flow.

   Note

   Click the icon again to expand the panel.

5. In the Task Type list on the left side of the canvas, drag the DTS data migration node to the blank area on the canvas.

6. Double-click the DTS data migration node.

7. On the configuration page, configure the DTS data migration node.

   Section	Parameter	Description
   Database	Source	Search for and select the source database.
   	Target	Search for and select the destination database.
   Table	Migrate Entire Database	Specifies whether to migrate the entire database. On: Migrates all tables in the source database. Off: Click Select tables to migrate.. In the Table Selection dialog box, select the tables to migrate and click Confirm.
   Synchronization Configuration	Mode	The synchronization mode is full migration. Note If data is updated in the source database during the full data migration, the updated data may not be migrated to the destination instance.
   	Type	Select the content type to synchronize: Data: Migrates table data. Structure: Migrates the table schema. Note If the destination table exists, you do not need to select Structure. If the destination table does not exist, you must select Structure.

8. Click Try Run.

   • If status SUCCEEDED appears in the last line of the log, the dry run is successful.

   • If status FAILED appears in the last line of the log, the dry run failed.

     Note

     • If the dry run fails, view the logs to identify the failed node and the cause of the failure. Then, modify the configuration and try again.

     • In standard mode for data warehouse development, a dry run of a DTS data migration node does not migrate data. This prevents production data from being migrated to the staging environment.

   After the dry run is successful, you can query the migrated tables in the SQL window of the destination database. For more information, see Query and modify a table schema.