February 17, 2021
Bulk DMS task operations with JQ and Bash
List all DMS task arns
aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn'
Stop all tasks
for t in $(aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn') ; do
aws dms stop-replication-task --replication-task-arn $task
done
Start all tasks with full reload
for t in $(aws dms describe-replication-tasks | jq -r '.ReplicationTasks[].ReplicationTaskArn') ; do
aws dms start-replication-task --replication-task-arn $task --start-replication-task-type reload-target
done