Home > News > How to compare and synchronize the differences of two database message types?

How to compare and synchronize the differences of two database message types?

To find and sync the differences of two database message types, you can accomplish it according to the following screenshots.

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

message types_option

Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database message types. You will find the differences in the compared strcture results.

message type_compare

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

message type_synchronize

Step 5: Click on "Sync" to synchronize the message types. Then you will find the "Action" status changed from "Action_1" to "Action_2". This tells you that the synchronization has been completed successfully.

message type_sync

Step 6: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed successfully.

message type_compared

Â

Tag: synchronize database message types,comparing databases,synchronizing database

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