Home > News > How to compare and synchronize the schemas?
How to compare and synchronize the schemas?
To compare and synchronize the schemas of two databases, you can use Schema Comarer or Database Comparer. The following is the detail of accomplishing 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 (Schemas) 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 schemas.
Step 4: Click "Synchronize", you can find the differences of schemas shown on the script.
Step 5: Click "Sync" to synchronize the schemas. Then you will find the "Action" status changed from "
" to "
".
" to "".
Step 6: Click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.
Tag: database schema compare,compare database schemas,synchronize sql
How to comapre and synchronize the synonyms?
How to compare and synchronize the differences of two database message types?
Readers also visit these :
- How to compare and synchronize the differences of two database triggers?
- How to compare and synchronize the differences of two database roles?
- How to compare and synchronize the view?
- How to compare and synchronize the partition functions?
- How to compare and synchronize the permissions?
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
