Home > News > How to compare and synchronize the differences of two database triggers?

How to compare and synchronize the differences of two database triggers?

The following screenshots will guide you through the steps of accomplishing it.

Step 1: Open SQL Server Comparison Expert, click "Connection" button, the connection dialog pops up.

onnection

Step 2: Click "Option" to open the Project Option, you can select the Object types (Triggers) to compare. Click "OK" to continue.

triggers_option

Step 3: Click "OK" to finish the connection. Click "Compare" button, you can view the differences in trigger structure.

triggers_compare

Step 4: Click "Synchronize", you can find the differences of triggers shown on the script.

triggers_synchronize

Step 5: Click "Sync" to synchronize the trigger. Then you will find the "Action" status changed from "Action_1" to "Action_2". This tells you that the synchronization has been completed successfully.

triggers_sync

Step 6: Click "Compare" button to view the synchronize trigger, then you will find there's no difference. In this way, the trigger synchronization is completed.

triggers_compared


Tag: synchronize database triggers,sql database compare,sql server data synchronization

Readers also visit these :

Related Questions :

Reviews & Award

  • "I love using this instead of gonig through the Microsoft wizard"

    - by John

  • "Reliable and simple to backup MSSQL, good for backup databases from one PC to another easily. "

    - by Paul