Set Up AWS DMS for Replication
About this task
Important:
In this task, angle brackets (< >) indicate placeholder text. If such placeholder text is part of a command, you must replace it with an appropriate value before running the command.
Procedure
- Access SQL Server Management Studio (SSMS).
- Create a blank database. This step is required to set up AWS DMS because the AWS DMS task requires a source location. You can delete this database after purging.
-
In AWS DMS, create a new endpoint:
-
Create an AWS DMS task:
- Access the AWS DMS console.
- In the AWS DMS console, create a task with the following details:
- Select the source and target endpoints created previously.
- Select the tables to be replicated.
- Select Migration type as Replicate data changes only.
- Select Migration task startup configuration as Manually later.
- Once the details are verified, create the task.
- You must modify and start this task once the filtering of ClonedDB is done.