CODEWITHSUNDEEP
tfs
majjam
majjam

Reputation: 1326

Best practice for tfs single files

We use TFS for our source control, which works fine for projects, however in addition to WinForms solutions, we also write short SQL statements that are used in isolation by the business. My question is, what would be best practice for storing these in TFS, my immediate thought is to create a 'SQLs' project and just store them that way, but is that overkill? Is there support for just adding a folder to TFS?

I found this link: http://geekswithblogs.net/slock/archive/2007/07/05/113704.aspx

But this seems to be adding items to an existing project / solution.

Many thanks,

Jamie

Upvotes: 0

Views: 124

Answers (3)

mikanyg
mikanyg

Reputation: 403

If you are using SQL Server Management Studio (SSMS) alot when working with SQL scripts, then you could also use the MSSCCI Provider, which provides source control integration to SSMS.

Upvotes: 0

DaveShaw
DaveShaw

Reputation: 52798

Yes, just use the Source Control Explorer in Visual Studio to add a "New Folder" where every you want.

New Folder

Then you can fill the folder full of files using File Explorer in Windows.

When you have done that, just use the "Add Items to Folder" option.

Add Items to Folder

Select the files you want and click Finish:

Add Files

Now if you look at your pending changes you will have all your files ready to check in.

One final note

When you are working on these files, you will have to use Source Control Explorer or the Power Toys shell extension to "check out" the files to remove the read only flag (don't clear it yourself). If you upgrade from TFS 2010 to 2012/3 then there are local workspaces available that mean you don't need to check out the files before editing (just like subversion).

Upvotes: 2

Sir Crispalot
Sir Crispalot

Reputation: 4854

How about giving TFS Power Tools a go?

One of the many features is a Windows Explorer shell extension that allows you to add, check out, etc. without having to use Visual Studio at all. You can simply put your files in a folder, and add the whole lot to TFS from the context menu.

If you've ever used TortoiseSVN, it's very similar and looks like this:

enter image description here

Upvotes: 1

Related Questions