SQL Server Scripts 2012 Project into Team Foundation Server 2012

3
votes

I have a SQL Server Scripts 2012 Project with multiple SQL queries and stored procedures.

We use Team Foundation Server 2012 to manage our source code for our Visual Studio Solutions.

How can I check in a SQL Server Scripts 2012 Project into TFS? If it is not possible how can I manage source control on this and allow multiple developers access to it?

3
sqlsql-servervisual-studio-2012tfsssms
Why is it difficult to add the .sql files to tfs? These are just regular files, or? - Snorre
@Snorre There are tons of .sql files some are just queries or stored procedures. They are all in a SQL Server Scripts Project we would like it to stay in that project because it manages our connections as well. But we have no place to source control it yet. We could manually add each separate file. - Andrew Quaschnick
I see. I would suggest creating database projects in visual studio and add the files there. There are several benefits by doing this. Another option is TFS power tools, which lets you add files right in Windows Explorer. You can easily add a folder tree in one operation, so it's not a big task. - Snorre

3 Answers

1
votes

You have a few options, here are two that I have used.

1: Download the TFS 2012 MSSCCI Provider:
This plugin allows you to access TFS from Microsoft SQL Server Management Studio. So you can easily add and check in\out those ssmssln and ssmsproj files from TFS.

64bit Download - 32bit Download

Once installed, in SSMS go to Tools-> Options -> Source Control to select the plugin.
If you don't see it then you probably need to install the other bit version.

After you have selected the plugin in the options window of SSMS, you will have a new menu option under "File" that will allow you to Add\Open\Change items in TFS from Sql Management Studio.

To add your Scripts solution using the MSSCCI plugin:
Open the project in SSMS, go to File -> Source Control -> Add Solution to Source Control

2. Add through VS using the "Add files to Source Control"
See here: To add a file that is not in a solution to version control

1
votes

I'm not quite sure why it would be a challenge to add the sql server scripts to TFS just as any other file in your visual studio solution. I've done this in a lot of projects with great success.

What is a challenge with databases though is to find a good strategy to handle branches and database versioning. I recommend that you have a look at Entity Framework Code First Migrations which handles this very nicely. Another approach is to use Chuck Norris Round house which is a more script based solution:

RoundHouse https://code.google.com/p/roundhouse/

Code First Migrations. http://msdn.microsoft.com/en-us/data/jj591621.aspx

If you start from scratch I would recommend the Code First Migrations approach, but if you allready have a lot of .sql files the second can work very well.

1
votes

The latest versions of MSSCCI still don't seem to work with SSMS 2012 - you'll need an older 32 bit version, here: http://visualstudiogallery.msdn.microsoft.com/en-us/bce06506-be38-47a1-9f29-d3937d3d88d6

Once this is installed you'll be able to see the "Team Foundation Server MSSCCI Provider" in the SSMS Source Control Plug-In selection.