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.
" to synchronize the trigger. Then you will find the "Action
" status changed from "
" 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.