Compare stored procedures with SQL Server Comparison Tool

You can compare selected pair of stored procedures by selecting appropriate procedures in Source and Target database and clicking the button "Compare Sel. Proc".

image

To compare all stored procedures at once click the button "Compare All".

image

The dialog box will pop up:

image

Select the checkbox "Procedures" and click the button "Compare".

Alternatively, you can click menu item Structure Comparisons | Bulk Comparisons, and then appropriate sub-menu - Simple or Details, depending on how many details you want to see in the comparison report.

image

At the end of the process, the report will be displayed.

You can also perform selective comparisons, where only the stored procedures specified by you will be compared. To do so select the menu item Structure Comparisons | Selective Comparisons and proceed the same way as with the Bulk Comparisons.

image

Testimonials

Here's why our customers love SQL Server Comparison Tool

View More