How do I use the validation feature in AWS DMS?

Resolution

Before you turn on the validation feature, review the limitations for AWS DMS task validation.

Turn on validation on a new task

Complete the following steps:

1. Open the AWS DMS console.
2. In the navigation pane, choose Database migration tasks.
3. Choose Create database migration task.
4. Enter the details for your Task configuration.
5. Under the Task settings section, select Validation with data migration or Validation without data migration.
   Note: Before you choose to validate without data migration, review the limitations for validation only tasks.
6. (Optional) To view replication task statistics with Amazon CloudWatch Logs, choose Turn on CloudWatch logs.
7. (Optional) Configure the Advanced task settings.
8. Choose Create task.

Turn on validation on an existing task

Complete the following steps:

1. Open the AWS DMS console.
2. In the navigation pane, choose Database migration tasks.
3. Select your task, and then check that the status of the task shows Failed or Stopped.
4. Choose Actions, and then choose Modify.
5. Under the Task settings section, select Validation with data migration or Validation without data migration.
   Note: Before you choose to validate without data migration, review the limitations for validation only tasks.
6. Choose Save.

View the results of the validation and revalidate tables

Complete the following steps:

1. Open the AWS DMS console.
2. In the navigation pane, choose Database migration tasks.
3. Select your task.
4. Under the Table statistics section, review the replication task statistics. If you turned on CloudWatch Logs during task creation, then choose CloudWatch metrics. On the dropdown list, select Validation.
5. (Optional) You can revalidate a table during a task.

Related information

Data validation task settings