You are here: Home > FAQ > FAQ More

How to compare and synchronize the differences between two database rules?

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.

Step 5: Click "Sync" 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.