Code Checkin Policy

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, andy.campbell.smith

Code Checkin Policy

Postby barry.hostead » Thu Jul 05, 2012 4:23 pm

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
barry.hostead
 
Posts: 1
Joined: Thu Jul 05, 2012 4:19 pm

Postby eddie davis » Mon Jul 09, 2012 1:59 pm

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
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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby Anna Hall » Wed Apr 24, 2013 10:06 am

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
Anna Hall
 
Posts: 3
Joined: Fri Apr 19, 2013 10:40 am


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests