Thanks for reaching out on the Redgate forum regarding your SQL Compare question.
Is this regarding SQL Compare instead of Data Compare?
You would be able to compare a Stored Procedure file against a database using SQL Compare.
SQL Compare looks at schema objects whilst SQL Data Compare looks at the data stored within objects
Using SQL Compare it would be a case of comparing between a Scripts Folder & your Database
The scripts folder would contain your stored procedure file
You may get an error message if you are only comparing the SP and don't have any schema statements in your folder. You should be able to Continue without resolving errors
By default your Database compare will be including all objects which will not match to your scripts folder.
You can set a filter on Stored Procedure object types and even go in and set a specific filter on the exact stored procedure you are comparing
After saving that you should have a compare between the stored procedure file and the stored procedure in your database.
Hope this is of use for your requirements.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal