Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Red Gate’s SQL Source Control and better SQL objects organization

Red Gate’s SQL Source Control (RGSSC) is very decent solution source control solution for database development. I am personally using it and despite it is still young product it is very helpful for me and rest of team members. I am not going to review this tool but I am going to look closer how you can improve your experience with it using SQL Treeo SSMS Add-In.

RGSSC is Management Studio Add-In which enables developer to track changes over SQL database and commit/update changes to source control repository (TFS, SVN and others) directly from SQL Server Management Studio (SSMS). For me, using SSMS for database development is still better way comparing to Visual Studio 2010 Database Projects (VS.NET) because I simply not got used to many drawbacks which VS.NET provides from database development point of view. But I will return back to this later.

RGSSC was quite life saver for me because you have quite few options of source control if you’re developing over dedicated local database. To make my life more comfortable I’ve developed SQL Treeo Add-In which allows me to create complex hierarchy of folders directly under my database bound to SVN. This folder (or groups) hierarchy is shared across all team members because this database is under source control. You can see short sample video here.

So all team members see the same picture of logical modules directly under our development database (green folders are created using SQL Treeo  Add-In):

Red Gate Source Control with custom folders using SQL Treeo Add-In

Logical groups for objects within SSMS standard nodes can be created for all basic SQL objects – tables, views, stored procedures, functions and even for databases.

Jakub Dvorak

Comments

Posted by Anonymous on 23 June 2011

Pingback from  Dew Drop – June 23, 2011 | Alvin Ashcraft's Morning Dew

Posted by Adam Mikolaj on 28 June 2011

Just about everything Redgate releases is pure gold. I love their products.

Leave a Comment

Please register or log in to leave a comment.