You are here: Home > FAQ > FAQ More

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.

connection

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

services_option

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

services_compare

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

services_synchronize

Step 5: Click "Sync" to synchronize the services. Then the "Action" status will be changed from "Action_1" to "Action_2.jpg".

services_sync

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.

services_sychronized_compare


: How to compare and synchronize the partition functions?
: How to compare and synchronize the queues?


Tags: database comparision   synchronize database services   database synchronization  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Can you show me the commands in each tab in the main interface?
Which license is best for me?
How to install Database Compare in my local disk?

Related Questions:

What is Database Integrity?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?
What is view (database)?