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 button "Compare All".

image

The dialog box will pop up:

image

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

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

image

At the end of the proces 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 menu item Structure Comparisons | Selective Comparisons and proceed the same way as with the Bulk Comparisons.

image


Still have questions? Just email sales@sql-server-tool.com

Our Customers Love SQL Server Comparison Tool

This is a wonderful tool and I use it all the time. ... In the short time that I have been using it, the question is, how did I ever get along without. Richard A. Stain
arrow