Disable Triggers

Before you begin

Delete unreferenced rows in CloneDB.

About this task

CloneDB contains all the triggers that the replicator added to ProductionDB. The triggers can modify the rows of CloneDB when an INSERT, UPDATE, or DELETE operation occurs on a ProductionDB table. This topic describes how to disable the triggers on CloneDB. This procedure is optional but we recommend that you perform the procedure to avoid any inadvertent changes to the data on CloneDB.

Procedure

  1. Access SQL Server Management Studio (SSMS).
  2. Create an SQL script for CloneDB using the following code example:
    sp_MSforeachtable "ALTER TABLE ? DISABLE TRIGGER ALL"
    Note:
    For more information, refer to the SSMS documentation.
  3. Run the script.
    The triggers on CloneDB are disabled.

What to do next

Stop all the SOA and Plant Applications services.