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".
To compare all stored procedures at once click button "Compare All".
The dialog box will pop up:
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.
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.
Still have questions? Just email email@example.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