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.
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.
Step 6: Click "Compare" buttonÂ to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed successfully.