This topic describes how to view the progress of a data migration or data synchronization task in the Data Transmission Service (DTS) console. For data migration tasks, you can view the details of schema migration and full data migration. For data synchronization tasks, you can view the details of schema synchronization and full data synchronization.

Procedure

A data synchronization task is used in this example. You can follow the same procedure to view the progress of a data migration task.

  1. Go to the Data Synchronization Tasks page.
    1. Log on to the DMS console.
    2. In the top navigation bar, click DTS.
    3. In the left-side navigation pane, choose DTS (DTS) > Data Synchronization.
  2. From the drop-down list to the right of Data Synchronization Tasks, select the region in which your data synchronization instance resides.
    Note If you use the new DTS console, select the region in which your data synchronization instance resides in the top navigation bar.
  3. On the Data Synchronization Tasks page, click the ID of the data synchronization instance that you want to view.
  4. In the left-side navigation pane, click Task Management. On the page that appears, clear Hide Completed Modules.
  5. Perform the following operations based on the synchronization type:
    • View the details of schema synchronization.
      1. In the Progress section, click the Schema Migration 1 module.
      2. Click the Task Details tab.
      3. Click a tab to view the schema synchronization details of a type of object. For example, click Table to view the schema synchronization details of tables. schema
        Note
        • To view the schema synchronization details of a specific object, you can enter the object name in the search box to search for the object.
        • To view the creation syntax of an object, you can find the object and click View Statements or View Foreign Keys in the Actions column.
        • To modify the creation syntax of an object, you can find the object and click Schema Revision in the Actions column.
    • View the details of full data synchronization.
      1. In the Progress section, click the Full Data Migration module.
      2. Click the Full Data Migration Progress tab.
      3. View the synchronization details of each object, or search for the synchronization details of a specific object by specifying the object name. full