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

  1. Access SQL Server Management Studio (SSMS).
  2. 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.
  3. In AWS DMS, create a new endpoint:
    1. Access the AWS DMS console.
    2. Navigate to Source Endpoints and create a new source endpoint.
    3. In the Connection section:
      • Endpoint Type: Source endpoint
      • Under Endpoint Configuration, provide a name for the source endpoint at Endpoint identifier.
      • Select Source Engine as Microsoft SQL Server.
      • Provide details like server IP, SQL port, and credentials.
      • Test the connection, and create the endpoint.
  4. 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.
  5. You must modify and start this task once the filtering of ClonedDB is done.

Results

AWS DMS is now set up for replication.

What to do next

Back up ProductionDB.