How can we help you today? How can we help you today?

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.
ITBobbyP85
0

Comments

1 comment

Sort by
  • DanC
    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:



    DanC
    0

Add comment

Please sign in to leave a comment.