Home > News > How to compare and synchronize the services?
How to compare and synchronize the services?
To compare and synchronize the services of two databases, just go through the following steps.
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 (Services) 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 databases services.
Step 4: Click "Synchronize", you can find the differences of services shown on the script.
Step 5: Click "Sync" to synchronize the services. Then the "Action" status will be changed from "
" to "
".
" to "".
Step 6: Click "Structure Result", and then click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.
Tag: database comparision,synchronize database services,database synchronization
Readers also visit these :
- How to compare and synchronize the data in different database tables?
- How to compare and synchronize the differences of two database defaults?
- How to compare and synchronize the differences of two database full text catalogs?
- How to comapre and synchronize the synonyms?
- 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
