Comparing just one SQL Server Stored Procedure between Environments
ITBobbyP85
Posts: 12 Bronze 1
in SQL Compare
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.
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.
Tagged:
Answers
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?