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.
Step 2: Click "Option" to open the Project Option, you can select the Object types (Triggers) to compare. Click "OK" to continue.
Step 3: Click "OK" to finish the connection. Click "Compare" button, you can view the differences in trigger structure.
Step 4: Click "Synchronize", you can find the differences of triggers shown on the script.
Step 5: Click "Sync" to synchronize the trigger. Then you will find the "Action" status changed from "
" to "
". This tells you that the synchronization has been completed successfully.
" to "". This tells you that the synchronization has been completed successfully.
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.
Tag: synchronize database triggers,sql database compare,sql server data synchronization
How to compare and synchronize the data in different database tables?
How to compare and synchronize the differences between two database rules?
Readers also visit these :
- How to synchronize automatically?
- How to compare and synchronize the stored procedures of two databases?
- How to compare and synchronize the differences between two database rules?
- How to compare and synchronize the data in different database tables?
- Restore SQL Database from LAN
Related Questions :
Popular articles
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
