Red Gate forums :: View topic - changing stored procedures
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

changing stored procedures

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
arzewski



Joined: 14 Sep 2010
Posts: 1

PostPosted: Tue Sep 14, 2010 4:25 pm    Post subject: changing stored procedures Reply with quote

is there a problem in source control for stored procedures if the developers in a team-based environment use DROP PROC and then CREATE PROC to make their changes in a stored procedure instead of using ALTER PROC ?

I am wondering if the source control service is smart enough to do a text difference and detect exactly which part of a procedure text was changed, and display that to the developer when he is ready to commit the changes and write a comment in the comment textfield.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Tue Sep 14, 2010 5:24 pm    Post subject: Reply with quote

SQL Source Control will do a textual comparison of the stored procedure as it is stored in the database. This stores all the text (including comments) in the batch that contained the stored procedure when it was created or altered, and will therefore exclude the DROP from consideration.

So SQL Source Control should behave as you expect.

Why not try it out for youself?

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group