Data consistency with AWS DMS data resync

This article discusses the AWS Database Migration Service (DMS) Data Resync feature, which helps detect and resolve data inconsistencies during database migrations without manual intervention.

• Data Resync is available for migrations from Oracle or SQL Server to PostgreSQL or Amazon Aurora PostgreSQL
• Enables automatic resolution of data discrepancies identified during validation
• Can be configured with a Cron-style schedule to run during low-activity periods
• Creates an `awsdms_validation_failures_v2` table to track and address mismatches

Key use cases include:

• Recovering from accidental record deletions on the target database
• Resuming CDC tasks after table errors by resyncing specific tables

The feature helps minimize manual intervention and ensures data consistency during database migrations.