You can view the details of your data migration instance, including the information about the struct migration, full data migration, and incremental data migration.
Procedure
Click the instance ID to go to the Instance Management page.
On the Instance List page in the Data Migration module, select the corresponding instance, and click the instance ID to go to the Instance Management page.
On the Instance Management page, click Instance Details to go to the details page.
On the details page, click Migration Details in the left-side navigation bar.
Struct Migration
Click Struct Migration. Then, you can view the details about struct migration performed by the instance. For example, you can view the migrated tables, views, functions, and procedures.
Click View Creation Syntax on the right side. Then, you can view the corresponding CREATE statements.
Full Data Migration
Click Full Data Migration. Then, you can view the details about the full data migration performed by the instance, including the source and destination database table information.
Incremental Data Migration
Click Incremental Data Migration. Then, you can view the details about incremental data migration in your task. The details show the current data pulling offset of DTS and the latest offset of your source database.
Note:
DTS records an offset in the format of BINLOG_NAME:BINLOG_POSITION. In the preceding example, mysql-bin.000049 is the name of the binary log file and 1010401550 indicates the offset in this binary log file. A DTS pulling offset indicates the progress of the incremental data migration step. If the DTS pulling offset is different from the latest offset of your source database, a latency occurs. You can calculate the latency based on the preceding offsets.
If you perform a data change in a table that is not migrated from the source database to the destination database, the DTS pull offset will not be updated due to existing filter conditions. However, the latest offset of the source database is updated in real time.