How to Automate RDS Backup Restore Validation Using AWS DMS?

Hello, Greetings for the day!

To begin with, the DMS data validation task is designed to validate the data which is migrated from a source to a target using the DMS service. Since the current use case does not involve a DMS migration, the automatic DMS data validation cannot be used. Thus, to support the DMS data validation feature, you would need to set up a DMS migration task to transfer the data from a source to a target, and then you could configure the DMS data validation to validate the migrated data.

In such scenario where data transfer is not being performed via AWS DMS, you would need to rely on manual validation. So, if you chose to go ahead with manual validation then you can automate this process by following below steps,

1. Here, you can leverage AWS Lambda functions and Amazon EventBridge. EventBridge can be used to capture the event "RestoreCompleted" that signifies the completion of the restore process, and a Lambda function can be triggered, if the "RestoreCompleted" event is logged.

[+] https://docs.aws.amazon.com/aws-backup/latest/devguide/logging-using-cloudtrail.html#service-name-info-in-cloudtrail

2. Within the Lambda function, you can write custom code to validate the data between the source and destination data. This code can be updated or modified as per your specific data validation requirements and logic.

To know more about event notifications with AWS Backup, you may refer to below documents.

[+] https://docs.aws.amazon.com/aws-backup/latest/devguide/monitoring.html

Further, if you would like to further dive deep and discuss on this, you may open a support case with AWS using the following link.

[+] https://support.console.aws.amazon.com/support/home#/case/create

Thank you!