changing stored procedures

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

changing stored procedures

Postby arzewski » Tue Sep 14, 2010 4:25 pm

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.
arzewski
 
Posts: 1
Joined: Tue Sep 14, 2010 4:20 pm

Postby David Atkinson » Tue Sep 14, 2010 5:24 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests