Data migration progress

Procedure

1. Log in to the Data Transmission Service (DTS) console.

   Note

   If you are automatically redirected to the Data Management (DMS) console, you can click the icon in the lower-right corner and then click to return to the classic DTS console.

2. In the left-side navigation pane, click Data Migration.
3. At the top of the Migration tasks page, select the region where your task is located.
4. On the Migration tasks page, click the ID of the destination database.
5. Follow the steps for the desired migration type.
   Note If a migration type is not displayed, it may be because you did not select it when configuring the task, or because the source database does not support it.

   • View schema migration details.
     1. In the left-side navigation pane, choose Migration Details > Schema Migration.
     2. Click a tab named after a schema object type, such as Tables, to view the migration details for schema objects. You can also use the search feature to filter for object names. The migration details table shows the Object Name, Source Database, Destination Database, Status, and Actions columns. You can expand an individual object to view its associated sub-objects, such as constraints, and their migration status.
        Note In the Actions column, click View Statements or choose View Foreign Keys > View Statements to see the object's creation syntax. A dialog box appears with the complete Data Definition Language (DDL) statement for the object. For example, a CREATE TABLE testschema.customer statement includes details such as field names, data types, constraints, and default values.
   • View full data migration details.
     1. In the left-side navigation pane, choose Migration Details > Full Data Migration.
     2. View the migration details for each object. You can also use the search box to filter for specific objects. On the Full Data Migration tab, the table displays information for each object, including Object Name, Source Database, Destination Database, Estimated Count, Completed Count, Duration (s), and Status. The full data migration is successful when the status for all objects changes to Completed.
   • View incremental data migration details.
     1. In the left-side navigation pane, choose Migration Details > Incremental Data Migration.
     2. View the migration details for each object. You can also use the search box to filter for specific objects. On the Incremental Data Migration tab, the table displays the Object Name, Source Database, Destination Database, and Status for each object. A status of No Latency indicates that the incremental data migration is running smoothly.

Related documents

• View the status and performance of a full data migration: View metrics such as throughput, RPS, read/write latency, and network latency.
• View the status and performance of an incremental data migration: View metrics such as the total number of migrated rows, throughput, and overall performance.