Generic Scripts

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Generic Scripts

Postby bermudabob » Thu Apr 17, 2014 4:22 pm

Hi,
We've recently put our databases into TFS 2013 with Source Control 3, and all is well with the world.

A query has arisen from our team, and I wasn't sure of an answer.

Basically, each team member gradually builds up a collection of very useful scripts in .sql files that they keep and use for time saving purposes. These aren't stored procedures and aren't tied to a particular database.

Now, we could create a VS project and stash these in that so that everyone can get access to it, but it would be nice to be able to have them available in SSMS directly.

Is there any way to do this? If not, can it be added to the 'nice to have in a future version' list?

Cheers,
Rob Marsh

Aero Developer
Scuderia Toro Rosso F1 Team.
bermudabob
 
Posts: 3
Joined: Thu Apr 17, 2014 4:11 pm

Postby David Atkinson » Thu Apr 17, 2014 4:35 pm

The official way is to install the MSSCCI provider and use a "Solution" in SSMS. I put "Solution" in quotes as they're very basic compared to those you get in VS.

The provider is here:
http://visualstudiogallery.msdn.microso ... 937d3d88d6
(you'll need to install the TFS client tools (Team Explorer) as well, but you probably have this already)

Another way could be to attach useful scripts to SQL Prompt snippets and store these in a shared network drive. This provides sharing, but not versioning.

I just found an article explaining how it might be possible to achieve sharing using Templates. I've not tried this myself, but it looks plausible:
http://tinyurl.com/oj7vgkd
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby bermudabob » Thu Apr 17, 2014 5:01 pm

Thanks for that - murphys law came into effect and I stumbled over the MSSCCI provider about a minute after I made the post.

We've gone with this method as its simple and we can group the queries by project for specific scripts with an additional Generic project for non-specific ones.

Cheers,
Rob Marsh

Aero Developer
Scuderia Toro Rosso F1 Team.
bermudabob
 
Posts: 3
Joined: Thu Apr 17, 2014 4:11 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests