To compare and synchronize the rules of two databases, you can refer to the following screenshots, which will guide you through the steps of completing it.
Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pops up.
Step 2: Click "Option" to open the Project Option, you can select the Object Types (Rules) to compare. Click "OK" to continue.
Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database rules.
Step 4: Click "Synchrinize", you can find the differences ofÂ rules shown on the script.
" to synchronize the rule. You will find the Action changed from "
" to "
Step 6: Click "Compare", you will find there are no differences in the rules of two database. This tells you that the synchronization is completed successfully.