THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Source code control - SQL Server and Oracle

One of the things that I find very poorly done in most SQL Server sites that I visit is source code control for database objects.

You can connect SQL Server Management Studio with source code control systems, to make it easier to manage scripts, etc. One way of doing this is to configure an SCCI (source code control interface) provider. You can get the one that works with SSMS here:

http://visualstudiogallery.msdn.microsoft.com/bce06506-be38-47a1-9f29-d3937d3d88d6/view/Reviews/

Once you've installed that, you'll find an "Add to source control" option appearing when you create new script projects. If it doesn't seem to be enabled, see this article:

http://technet.microsoft.com/en-us/library/ms173550(v=SQL.105).aspx

You'll also need a TFS (Team Foundation Services) server or an SVN server. A really good option now is the TFS Online offering which is also free for up to 5 users:

http://tfs.visualstudio.com/en-us/pricing/tfs-information 

Another option to consider, particularly if you work with other database engines as well are the 3rd party tools. I've previously mentioned the Red-Gate source code control tools. You'll find info on them here:

http://www.red-gate.com/products/sql-development/sql-source-control/

A key advantage of these is that they are pretty easy to use and work with a wider variety of source code control engines. As well as TFS and SVN, they work with Git, Mercurial, Vault, Perforce and others.

Today they have announced updated support for Oracle:

http://www.red-gate.com/products/oracle-development/source-control-for-oracle/

It works with SVN and TFS.

Either way, there are lots of offerings out there now. It's important that you start to investigate one of them if you haven't already done so.

Published Thursday, September 12, 2013 1:37 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

smuser12 said:

There's also SSDT 2012 in the most uptodate version from March 2013 i think. Seems to work nicely, though as an add-in from within visual studio 2012, but you can use the visual studio 2012 shell as basis to install SSDT 2012 on.

September 12, 2013 5:07 AM
 

Manson said:

Great

September 12, 2013 9:15 PM
 

Henri said:

We are working with SSDT to and loving it. Source control and more...

September 14, 2013 8:15 AM
 

ta.speot.is said:

Use SQL Server Data Tools. For schema management it's much better than SSMS.

September 14, 2013 6:19 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement