Disable ProductionDB Replication

Before you begin

  1. If you have disabled triggers on CloneDB, enable them.
  2. In AWS DMS, stop the AWS DMS task. If you do not do so, the TLOG truncation warning message appears for the AWS DMS task.
  3. Back up the replication database:
    1. Access SSMS.
    2. In the Generate SQL Script window:
      1. Select the To create or enable the components option.
      2. Select Generate Script > Save to File.
      3. Enter replication_script, and then select Save.

About this task

Before you configure Plant Applications to use CloneDB as the production database, you must disable the replication for ProductionDB.
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 the AWS DMS console, and select the ongoing replication task.
  2. Stop the task.
  3. Access SQL Server Management Studio (SSMS).
  4. Disable publishing and distribution for ProductionDB, and then remove all replication objects from the local publication of the database:
    1. Select Replication > Local Publications.
    2. Right-Click [<production database>]:awsdms, and then select Generate Scripts.
    Note:
    For more information, refer to the SSMS documentation.

What to do next

Switch to CloneDB.