Home > News > How to compare and synchronize the queues?

How to compare and synchronize the queues?

You can refer to the following screenshots about comparing and synchronizing the queues of two databases.

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 (Queues) to compare. Click "OK" to continue.

queues_option

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

queues_compare

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

queues_synchronize

Step 5: Click "Sync" to synchronize the queues. Then you will find the "Action" status changed from "Action_1" to "Action_2.jpg".

queues_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.

queues_sychronized_compare


Tag: compare sql databases,sychronize database queues,database compare utility

Readers also visit these :

Related Questions :

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