This topic describes how to view the data verification details of data migration or data synchronization tasks in Data Transmission Service (DTS).

Prerequisites

A data migration or data synchronization task is created and data verification is configured for the task. For more information, see Enable data verification.

Note The data verification feature is in public preview. During public preview, you can use the feature free of charge.

Procedure

  1. Go to the Data Synchronization Tasks or Data Migration Tasks page.
    1. Log on to the Data Management (DMS) console.
    2. In the top navigation bar, click DTS.
    3. In the left-side navigation pane, choose DTS (DTS) > Data Synchronization or DTS (DTS) > Data Migration.
    Note
  2. From the drop-down list to the right of Data Synchronization Tasks or Data Migration Tasks, select the region in which your DTS instance resides.
    Note If you use the new DTS console, you must select the region from the region drop-down list to the right of Workbench in the top navigation bar.
  3. Click the ID of a data migration instance or data synchronization instance to view the instance details.
  4. Optional: In the left-side navigation pane, click Task Management.
  5. In the Progress section, click the Full Data Verification or Incremental Data Verification tab to view the data verification details.

    • Basic Information

      In the Basic Information section, you can view information about the data verification task, such as the start time, verification time rules, status, actions, and error messages. The actual information displayed in the console prevails.

      Note
      • After the data verification task enters the Running state, you can restart, pause, or stop the task based on your business requirements. You cannot restart a data verification task that is complete. For more information, see What to do next.
      • For a full data verification task, we recommend that you view verification details after the status of the task changes to Completed. For an incremental data verification task, we recommend that you view verification details after the current offset is obtained and the offset is later than the point in time when incremental data is changed.

    • Verification details

      In the Check Details section, you can view table-specific data verification results such as the source and destination database names, table names in the source and destination databases, data verification state, and the point in time of data verification.
      Note
      • The verification results are displayed in descending order based on the values of Number of Inconsistent Records in the Check Details section.
      • If the value of Number of Inconsistent Records is 0, data between the source and destination instances is consistent. In this case, you do not need to view or download the verification report because the verification report does not contain data.
      • If the value of Number of Inconsistent Records is not 0, data inconsistency exists between the source and destination instances. In the Actions column, you can click View Report or Download Report based on your business requirements. Then, you can manually modify the inconsistent data based on the report.
      • During incremental data verification, changes of the same data record within a certain period of time are merged. Therefore, the number of data records displayed for an incremental verification task may be less than that of incremental data changes.

What to do next

After you modify the inconsistent data based on the report, you can perform the following operations in the Progress section to verify data consistency between the source and destination instances again.

Note
  • When a full data verification task is running, you can only pause the task.
  • When an incremental data verification task is running, you can pause or stop the task. When an incremental data verification task is paused, you can only restart the task. The incremental data verification task cannot be resumed after it is stopped.

  • Full data verification

    1. Click the Full Data Verification tab.
    2. Optional: Click the Basic Information tab.
    3. Click Restart to the right of Actions.
    4. Click OK in the dialog box that appears.

  • Incremental data verification

    1. Click Incremental Data Verification.
    2. Optional:Click the Basic Information tab.
    3. Click Pause to the right of Actions.
    4. Click OK in the dialog box that appears.
    5. Click Restart to the right of Actions.
    6. Click OK in the dialog box that appears.