Red Gate forums :: View topic - Code Checkin Policy
Return to www.red-gate.com RSS Feed Available

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

Code Checkin Policy

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
barry.hostead



Joined: 05 Jul 2012
Posts: 1

PostPosted: Thu Jul 05, 2012 4:23 pm    Post subject: Code Checkin Policy Reply with quote

Hi All,

Not sure if this is possible, but is there anyway to define a checkin policy inside/ alongside SSC to stop developers checking in database code that they shouldn't?

i.e. Prevent against the use of SELECT *
OR ensure that all tables have specific columns contained within them (RowID/ Loadeddate)

Barry
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Mon Jul 09, 2012 1:59 pm    Post subject: Reply with quote

Hi Barry

Within SQL Source Control there is no facilty to define a checkin policy. However there is new Red Gate product called SQL Test, see this LINK

You can then create your own custom tests to
Quote:

Prevent against the use of SELECT *
OR ensure that all tables have specific columns contained within them (RowID/ Loadeddate)


You and your colleagues can run the tests prior to committing the changes via SQL Source Control.

I hope this helps.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Anna Hall



Joined: 19 Apr 2013
Posts: 3

PostPosted: Wed Apr 24, 2013 10:06 am    Post subject: Reply with quote

Hi Barry,

SQL Source Control will now let you enforce TFS policies (if you use Microsoft's Team Foundation Server as your source control system).

You can create a custom TFS policy to enforce this behavior (see here: http://msdn.microsoft.com/en-us/library/bb668980.aspx).
Or you can use the testing policy to run SQL test for each checkin: http://stackoverflow.com/questions/4105086/enforce-tests-run-before-tfs-check-in.

More general information on TFS is here: http://msdn.microsoft.com/en-gb/vstudio/ff637362.aspx

Anna
Back to top
View user's profile Send private message
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