asp.net + MS SQL Server: Best Source Control

views:

287

answers:

+2 Q:

asp.net + MS SQL Server: Best Source Control

I work on a growing web team that needs to adopt a Source Control system. We looked into Source Safe, but were put off by it's lack of SQL Server source control.

The Visual Studio Team System range looks like it does the trick, in terms of source code + database - but I must admit to be confused by the various versions.

So my questions are (from those with experience):

Is there a free Source Control system that works well with asp.net + SQL Server?
Is VS Team System worth it - for a team of less than five developers?
Finally - if Team System is the best choice, which edition is the best fit for a small team?

Thanks

+4 A:

Particularly for a small team, you pretty much can't go wrong with Subversion. It's free, open source, and very well supported by the community.

Greg Hewgill 2009-08-11 10:28:58

We have found this to be very easy to use and maintain.

Hooloovoo 2009-08-11 10:42:17

Is there a good guide for getting started? I'm looking into 'VisualSVN Server' at the moment. At the moment it all feels like a strange new world!

Peter Bridger 2009-08-11 10:51:11

Although I haven't used that particular version, I understand VisualSVN Server is a good way to get started. Required reading is also Version Control with Subversion, a free online book: http://svnbook.red-bean.com

Greg Hewgill 2009-08-11 10:59:28

Thanks for the link - I shall read this

Peter Bridger 2009-08-11 11:00:12

We're very pleased with Subversion here at Red Gate, and we use a combination of Tortoise and VisualSVN. You might be interested to know that we're integrating SQL Server source control support into SSMS in our upcoming tool, SQL Source Control. For more info visit http://www.red-gate.com/products/SQL_Source_Control/index.htm

David Atkinson 2009-10-24 17:29:43

Just a note to say that SQL Source Control 1.0 has now been shipped!

David Atkinson 2010-06-30 12:15:04

+1 A:

Alot of people use Subversion. Place all your SQL into text files and place them in the repository.

Dead account 2009-08-11 10:29:43

+1 for subversion. Having been using TFS for the last few months, I'm missing subversion so much! Suggest paring it with VisualSVN for a nice Visual Studio Experience

MPritch 2009-08-11 10:36:06

Very interesting - just posted above about looking into VisualSVN Server. We are using Visual Studio, so it sounds like this will work well.

Peter Bridger 2009-08-11 10:51:48

I have the exact same problem, thankfully my company is under 3 years old and we can apply for Biz Spark, which means we get TFS for free. I really like TFS, it includes project management, bug tracking and build management as well as version control which is very useful. It also has some database tools built for SQL Server.

If you have the money or Biz Spark go for TFS, if not then take a look at GIT. It's another free source control system that takes a different approach to source control.

Stephen lacy 2009-08-31 15:56:57

ansaurus

tags:

views:

answers:

asp.net + MS SQL Server: Best Source Control

related questions