SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What source control product do you use?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

TimS
Posting Yak Master

USA
198 Posts

Posted - 02/03/2006 :  13:12:14  Show Profile  Reply with Quote

I use MS Visual Source Safe; what do you all use?

I have been reading new groups and thier seems to be a lot of people saying Source Safe is a bad product.

Tim S

TG
Flowing Fount of Yak Knowledge

USA
5932 Posts

Posted - 02/03/2006 :  13:14:00  Show Profile  Reply with Quote
We use MS VSS also

Be One with the Optimizer
TG
Go to Top of Page

SQLServerDBA_Dan
Aged Yak Warrior

USA
752 Posts

Posted - 02/03/2006 :  13:26:21  Show Profile  Reply with Quote
Vault.
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17434 Posts

Posted - 02/03/2006 :  17:45:57  Show Profile  Reply with Quote
CVS

----------------------------------
'KH'


Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35940 Posts

Posted - 02/03/2006 :  17:56:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
We used to use VSS but now we use Rational ClearCase.

I'd agree that VSS is a bad product.

Tara Kizer
aka tduggan
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/04/2006 :  06:33:31  Show Profile  Reply with Quote
We use Sub Version. Its based on CVS (AFAIK), and seems to have a good following.

Good points are:

1) Open Source / Free

2) Merge-on-checkin - rather than Lock-at-checkout (although "Lock" method is supported too)

3) Checkin is atomic.

4) Handles binary (etc) files too.

5) Repository much more bullet proof than VSS

6) Runs with a stand-alone repository, or the flashy Unix equivalent stuff

7) Nice front end for Windows ("Tortoise") fully integrated into Windows Explorer.

8) Efficient transfer from Client-Server - works well over slow links etc.

For me [apart from (5), which is obviously very important] (2) is the critical thing. Locking a file at checkout makes it jolly hard for you and your colleagues to work naturally on things that involve a bunch of different files.

With SubVersion you just work on your local files. Then you commit your changes whenever you want to. If someone else has changed a file whilst you were working on your copy you have to "merge" your changes into the newer master copy.

You can also "update" your local files from the repository. Anything you haven't changed locally, but which has changed in the repository, is freshened up. So you can do that a few times a day to make sure that you have the latest versions of over peoples stuff that you might need to work on a bit later on.

This system allows you to, for example, update the source code on your laptop, head off to the beach/skiing for a week , work on the code, and then check it back in, with any necessary merges and without locking your colleagues out of the files .

If you have to have VSS compatibility then Eric Sink's company [forgotten the name] (SourceGear) make a product to work just like VSS. They also make a product called Vault which is a grown up version of CVS / Sub Version, and is also highly thought of.

Kristen

Edited by - Kristen on 02/04/2006 09:19:22
Go to Top of Page

mmarovic
Aged Yak Warrior

Czech Republic
518 Posts

Posted - 02/04/2006 :  06:50:43  Show Profile  Visit mmarovic's Homepage  Send mmarovic a Yahoo! Message  Reply with Quote
Subversion + Tortoise.

Edited by - mmarovic on 02/04/2006 07:14:53
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/04/2006 :  07:11:32  Show Profile  Reply with Quote
To further bang that drum some light reading!! :

http://discuss.joelonsoftware.com/default.asp?joel.3.303108.25

Kristen
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 02/04/2006 :  09:13:34  Show Profile  Visit graz's Homepage  Reply with Quote
Eric's company is called SourceGear. Their product is Vault which I think works in either checkout mode (VSS) or edit-merge mode (subvesion). I use Subversion + Tortoise. Works like a champ and the price is right.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

TimS
Posting Yak Master

USA
198 Posts

Posted - 02/15/2006 :  09:58:56  Show Profile  Reply with Quote
Thank you all for your reply.

I plan to look into cvs & Subversion for use at home.
And, when I have gotten it to work and compare the differences, I will be able to bring the subject up at work.

Tim S
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/08/2007 :  22:22:53  Show Profile  Reply with Quote
See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63148

Edited by - Kristen on 01/08/2007 22:23:25
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2048 Posts

Posted - 11/16/2011 :  06:02:08  Show Profile  Reply with Quote
I know this is an old thread but I wanted to revisit it with the simple question, what version control system do you use now?

We are in the throws of moving to Mercurial but I haven't yet got it working with SSMS. Anyone had any better luck than me or am I doomed to the command line for my SQL stuff?

Steve

-----------

What color do you want that database?
Go to Top of Page

uberman
Posting Yak Master

158 Posts

Posted - 11/16/2011 :  06:14:00  Show Profile  Reply with Quote
Sourcegear Vault
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/16/2011 :  13:43:36  Show Profile  Reply with Quote
We still use SVN (Subversion) + Tortoise

I don't know, off hand. how long we have been using it, but it was installed on the current server in 2005.

So far we have had no issues at all.
Go to Top of Page

mmarovic
Aged Yak Warrior

Czech Republic
518 Posts

Posted - 11/17/2011 :  04:35:35  Show Profile  Visit mmarovic's Homepage  Send mmarovic a Yahoo! Message  Reply with Quote
I changed employers a few times in the meantime. The company I worked for 3 years used Team Foundation Server.

However, subversion stays my preffered VCS.

Mirko

My blog: http://mirko-marovic-eng.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000