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.
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 "
".
" 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.
Tag: database compare,synchronize database rules,sql server 2000 compare
How to compare and synchronize the differences of two database triggers?
How to compare and synchronize the stored procedures of two databases?
Readers also visit these :
- How to synchronize automatically?
- How to compare and synchronize the stored procedures of two databases?
- How to compare and synchronize the differences of two database triggers?
- How to compare and synchronize the differences of two database defaults?
- How to compare and synchronize two database functions?
Related Questions :
Popular articles
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
