Automate a Data Migration Service (DMS) Task

Hi Raja,

You can leverage the Amazon EventBridge Scheduler to schedule that DMS task to run everyday at 6 AM for your timezone. You can set the target as the StartReplicationTask under AWS Database Migration Service shown in the screenshot below:

Note that this requires an IAM role that grants the EventBridge service permissions to start this task. The wizard for creating this schedule will provide options for choosing an existing IAM role or link to create a new one.

Let me know if you have any other questions

Loc, Data Architect, AWS ProServe

Take a look at this solution: Automating database migration and refreshing activities with AWS DMS.

if you want to create a eventbridge that resume the task (because you need start the first time manually) you need to create a eventbridge schedule for a lambda, that create a iam role automatically (because dms:StartReplicationTask dosnt). After that, you can edit the rule and add the "dms:StartReplicationTask" action into the role created, like this:

{ "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Action": [ "lambda:InvokeFunction", "dms:StartReplicationTask" ], "Resource": "*" } ] } (can delete the lambda action if you want)

when you have this, now you can change the target service to DMS StartReplicationTask, whith the arn for your dms task and "StartReplicationTaskType": "resume-processing" (important resume-processing)

Cheers