Enable Triggers on Cloned Database

Before you begin

Start replication.

About this task

You must enable the triggers on CloneDB again after you disengage the replicator. This procedure is required only if you have disabled triggers on CloneDB.

Procedure

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

What to do next

Disable ProductionDB replication.