This topic describes how to view the progress of a data migration task in the Data Transmission Service (DTS) console. A task defines configurations for a data replication workload, such as the connections to the source and target data stores. You can also view the task status to track the progress of your replication workloads. A data migration task consists of several phases, namely schema migration, full data migration, and incremental data migration.

Procedure

  1. Log on to the 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 the target instance resides.
    Select a region
  4. On the Migration Tasks page, click the ID of the target instance.
  5. Depending on the migration phase, only relevant details are displayed. Perform the following operations accordingly:
    • View the details of schema migration.
      1. In the left-side navigation pane, choose Migration Details > Schema Migration.
      2. Click the tab that indicates a type of schema object to view the migration details. For example, click Tables to view the migration details of tables. You can search for the migration details of a specific object by specifying the object name. Details of schema migration
        Note You can click View Creation Syntax or choose View Index Foreign Keys > View Creation Syntax in the Actions column to view the CREATE statement of the object.View the creation syntax of an object
    • View the details of full data migration
      1. In the left-side navigation pane, click Migration Details > Full Data Migration.
      2. View the migration details of each object or search for the migration details of a specific object by specifying the object name.Details of full data migration
    • View the details of incremental data migration
      1. In the left-side navigation pane, choose Migration Details > Incremental Data Migration.
      2. View the migration details of each object or search for the migration details of a specific object by specifying the object name.Details of incremental data migration

References