Red Gate forums :: View topic - Generic Scripts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Generic Scripts

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bermudabob



Joined: 17 Apr 2014
Posts: 3

PostPosted: Thu Apr 17, 2014 4:22 pm    Post subject: Generic Scripts Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Thu Apr 17, 2014 4:35 pm    Post subject: Reply with quote

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.microsoft.com/bce06506-be38-47a1-9f29-d3937d3d88d6
(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
Back to top
View user's profile Send private message Send e-mail
bermudabob



Joined: 17 Apr 2014
Posts: 3

PostPosted: Thu Apr 17, 2014 5:01 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group