To compareÂ and synchronize the stored procedures of two databases, the following screenshots willÂ show you the steps.
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 (Stored Procedures) 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 stored procedures.
Note: The function of the icon ()Â is to hide the same item.
Step 4: You will find the differences in the compared strcture results. Click "Synchronize", you can find the differences of stored procedures shown on the script.
Step 5: Click on "Sync", then you will be prompted to backup the target database. If you want to backup your database manually, please choose "No" in the confirm dialog.
" and you will see the action status changed from "
" to "
". This tells you that the synchronization has been completed successfully.
Step 7: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed.