This topic describes how to restart a failed data migration task. You can perform this operation if your data migration task is in the Migration Failed status during the schema migration or full data migration phase.

Restart a migration task that failed during schema migration

The task may fail during schema migration due to various causes. A typical cause is that unsupported data types are included in the migration task.

  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 destination instance resides.Select a region
  4. Use one of the following methods to resolve the issues with the failed task:
    • Method 1
      1. Find the target task and click View Cause and Rectify.View Cause and Rectify
      2. Fix the issue based on the cause of failure that is displayed in the View Cause and Rectify message. For example, you have to modify table definitions of the source database to convert the columns into supported data types.
      3. Click Restart Task.
    • Method 2
      1. Click the ID of the target task.
      2. In the left-side navigation pane, choose Migration Details > Schema Migration.
      3. On the Schema Migration page, find the object that causes the migration failure and click Rectify in the Status column.Rectify
      4. Fix the issue based on the cause of failure that is displayed in the Rectify dialog box. For example, you have to modify table definitions of the source database to convert the columns into supported data types.
      5. Click Rectify.
        Note
        • If the failure is not fixed, the Rectify dialog box does not close and shows the cause of failure. You must continue troubleshooting based on the cause of failure until all issues are resolved.
        • If the troubleshooting is successful, the Schema Migration page appears and the status of the object changes to Finished.
  5. If no objects are in the Failed status, DTS proceeds with the data migration task, for example, entering the full data migration process.

Fix a migration task that failed during full data migration

  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. Find the target task and click View Cause and Rectify.

    DTS allows you to fix a task that fails during full data migration due to the following reasons.

    Note If a task fails during full data migration due to other reasons, DTS provides only the Ignore option. The object that causes the failure is not migrated to the target database.
    • The connection to the source or target database failed or timed out.

      Troubleshoot the issue, make sure that the connection is successful, and then click Restart Task.

    • The storage space of the target instance is insufficient or the instance is locked.

      Upgrade the target instance to a larger size or clear the log files, and then click Restart Task.

    • MyISAM tables in the source database are corrupted.

      Repair the MyISAM table in the source database, and then click Restart Task. For more information, see the official MySQL documentation.

  5. In the dialog box that appears, fix the issue based on the cause of failure.
  6. Click Restart Task.