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.
Step 2: Click "Option" to open the Project Option, you can select the Object Types (Message types) 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 message types. You will find the differences in the compared strcture results.
Step 4: Click "Synchronize", you can find the differences of stored procedures shown on the script.
Step 5: Click on "Sync" to synchronize the message types. Then you will find the "Action" status changed from "
" to "
". This tells you that the synchronization has been completed successfully.
" to "". This tells you that the synchronization has been completed successfully.
Step 6: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed successfully.
Â
Tag: synchronize database message types,comparing databases,synchronizing database
Readers also visit these :
- How to compare and synchronize the stored procedures of two databases?
- How to compare and synchronize contracts?
- How to compare and synchronize the schemas?
- How to compare and synchronize the queues?
- How to compare and synchronize the partition functions?
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
