Home > News > How to compare and synchronize the stored procedures of two databases?

How to compare and synchronize the stored procedures of two databases?

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.

stored procedures_synchronize

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.

Step 6: Click "Yes" 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.

stored procedures_compared

How to compare and synchronize the stored procedures of two databases?

Tag: database compare,synchronize database stored procedure,compare sql databases

Readers also visit these :

Related Questions :

Popular articles

Reviews & Award