Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Reloading tables during a task

Focus mode
Reloading tables during a task - AWS Database Migration Service

While a task is running, you can reload a target database table using data from the source. You might want to reload a table if, during the task, an error occurs or data changes due to partition operations (for example, when using Oracle). You can reload up to 10 tables from a task.

Reloading tables does not stop the task.

To reload a table, the following conditions must apply:

  • The task must be running.

  • The migration method for the task must be either full load or full load with CDC.

  • Duplicate tables aren't allowed.

  • AWS DMS retains the previously read table definition and doesn't recreate it during the reload operation. Any DDL statements such as ALTER TABLE ADD COLUMN or DROP COLUMN that are made to the table before the table is reloaded can cause the reload operation to fail.

Note

DMS applies the TargetTablePrepMode setting before reloading the table. If you set TargetTablePrepMode to DO_NOTHING, you must manually truncate the table first.

AWS Management Console

To reload a table using the AWS DMS console
  1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

    If you are signed in as an IAM user, make sure that you have the appropriate permissions to access AWS DMS. For more information about the permissions required, see IAM permissions needed to use AWS DMS.

  2. Choose Tasks from the navigation pane.

  3. Choose the running task that has the table you want to reload.

  4. Choose the Table Statistics tab.

    AWS DMS monitoring
  5. Choose the table you want to reload. If the task is no longer running, you can't reload the table.

  6. Choose Reload table data.

When AWS DMS is preparing to reload a table, the console changes the table status to Table is being reloaded.

On this page

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.