Comparing just one SQL Server Stored Procedure between Environments

Is there a written procedure or YouTube that explains how to compare just one SQL Server Stored Procedure between Environments?

I don't want to compare every SQL Server Stored Procedure...Just one

And I think there's a way as well to generate a script for deployment as well. Are there instructions on how to do that as well.

Thanks in advance for your review and am hopeful for a reply.


  • Options
    Hi @ITBobbyP85

    Unfortunately there's no way to specify a single object to compare and the only method I can think of would be to create a limited access user who can only see that procedure to compare.

    With regards to generating a script, you can tick the box as shown here:

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our 
    Help Center?

Sign In or Register to comment.