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 DataBase Compare, 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



: How to compare and synchronize the differences of two database triggers?
: How to compare and synchronize the stored procedures of two databases?



Tags: database compare   synchronize database rules   sql server 2000 compare  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Which license is best for me?
How to compare and synchronize the permissions?
How to compare and synchronize two database users?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?