Code Checkin Policy

• 
  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 D July 09, 2012 08:59

  - 0 +
• 
  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

  [Deleted User] April 24, 2013 05:06

  - 0 +

Add comment

Please sign in to leave a comment.