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

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.

connection

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

rules_option

Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database rules.

rules_compare

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

rules_script

Step 5: Click "Sync" to synchronize the rule. You will find the Action changed from "Action_1" to "Action_2".

rules_sync

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.

rules_compared


Tag: database compare,synchronize database rules,sql server 2000 compare

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