Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Code Repository

Author  Topic 

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2010-11-01 : 16:00:56
Hello,

We have 4 programmers that are going to be working on a very large project over the next 2 years and we are in need of a code repository. We would like to store, share, check-in/check-out, etc.

I have looked at Team Foundation Server but my initial thought is this is way over-kill (requires SQL and SharePoint). But since we have never used a repository before I can't say for sure.

Any suggestions?

If I posted this in the wrong area, please forgive me.

Regards,
Terry

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-01 : 16:11:36
CVS and Subversion are common free tools. Or did you want to purchase something?

I've used Perforce, VSS, and ClearCase in the past. I would not recommend CC. And really I wouldn't recommend VSS either.

http://www.codinghorror.com/blog/2006/08/source-control-anything-but-sourcesafe.html

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2010-11-01 : 16:18:30
I don't mind purchasing a product as long it's decent. I just want something that'll provide the necessary functionality ... but without the bloat that you get with a lot of products.

Thanks,
Terry

Thanks,
Terry
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-01 : 16:19:41
Take a look at Subversion and CVS then. Why pay if you can get it for free?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-01 : 16:19:48
You don't need Sharepoint for TFS, just a SQL Server. If you have an MSDN Subscription you can create a TFS 2010 server without an additional license:

http://blogs.msdn.com/b/buckh/archive/2009/10/20/tfs-2010-server-licensing-it-s-included-in-msdn-subscriptions.aspx

They also have the Everywhere feature set in 2010:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=AF1F5168-C0F7-47C6-BE7A-2A83A6C02E57&displaylang=en
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-01 : 16:22:02
You could also check out (hehe, I crack myself up):

http://www.sourcegear.com/vault/

It's not free for team/corporate use but it's a lot cheaper than TFS.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-11-01 : 16:37:10
We have used Subversion and Tortoise (front end tools for Windows) for years and are very happy with it. People seem to say they are changing to GIT instead. I haven't figured out why though (and maybe its more Talk than Action anyway)

Make sure you experiment with Branches before doing any serious checking in of real code. You can wind up with lots of sub-folders of variations of your source code, under your "checked out" folder, and its good to get that sorted out / understood whilst you are still at the "wipe the repository and start over" stage

Links to somewhat dated discussions (below), but I think still relevant (particularly discussion around Checkout-and-lock (which we hate here) and Change-anything-you-like and then resolve-conflicts-at-checkin (which we like, and in reality very rarely have a check-in-conflict - well, if we don't checking for Months we would have conflicts, but checkin-often is a good strategy for all sorts of reasons. Not least of which is that checkin-when-you-like works well if you are working on a laptop away from the office - you have all source code with you, you can view / edit anything, and just check it in when you get back to the office. Who wants to be using Checkout-and-lock with a 4G card on a Mobile phone at 40,000 feet?!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61248
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63148

"working on a very large project over the next 2 years"

Other things you may want to aim for:

Automated Daily build
Automated regression test

First job of the day: fix bugs found overnight on yesterday's code. Its still fresh in your mind what you did/changed yesterday that caused the problem, and you haven't yet written a ton of code that depends on the method you built yesterday that now turns out to be buggy.

The alternative of "build code for months and then try to remember what you did when debugging reveals bugs" is a complete PITA and a huge project-timeline-killer.

Aggghhhhh, what am I doing trying to explain this? people like Joel Spolsky describe this stuff far better than I ever could. See how you fair on "The Joel Test":

http://www.joelonsoftware.com/articles/fog0000000043.html

IMHO you absolutely need 1-5, and 12 (plus automated regression test above); I figure that even bad code shops have enough within 6-11 to get by :)

Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2010-11-02 : 04:25:40
And talking about Joel....have a look at his Repository product. Web based & low cost.

http://www.fogcreek.com/Kiln/
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-11-02 : 04:32:35
In which case might as well use his Bug Tracking tool too

Free for 2 users or less - ideal for small projects.

http://www.fogcreek.com/fogbugz/
Go to Top of Page
   

- Advertisement -