Sunday, April 27, 2014

Using Team Foundation Server 2013 with SQL Server Management Studio

You may know that SQL Server Management Studio does not provide any source control provider support out-of-the-box as is the case with editions of Visual Studio starting with Visual Studio 2010.

This can be shown by going into the Tools-->Source Control menu in SQL Server Management Studio:



Fortunately, there is a way to provide Team Foundation Server 2013 integration with SQL Server Management Studio.  You can use the MSSCCI Providers that are available free to download from Visual Studio Gallery:

TFS 2013 32-bit MSSCCI Provider
http://visualstudiogallery.msdn.microsoft.com/06c8e056-7f77-4a5c-9b8b-49318c143df8

TFS 2013 64-bit MSSCCI Provider
http://visualstudiogallery.msdn.microsoft.com/22d38324-051c-4f04-9379-ff78e7116c8d

Since SQL Server 2012 still only supports 32-bit, we will need to download and install the 32-bit MSSCCI Provider.

Once you install that provider, you will now see the following option in SQL Server Management Studio:


That is it!!  That is all you need to do to enable Team Foundation Server 2013 support for SQL Server Management Studio!

No comments:

Post a Comment