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 2000 Forums
 SQL Server Administration (2000)
 What source control product do you use?

Author  Topic 

TimS
Posting Yak Master

198 Posts

Posted - 2006-02-03 : 13:12:14

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
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-02-03 : 13:14:00
We use MS VSS also

Be One with the Optimizer
TG
Go to Top of Page

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2006-02-03 : 13:26:21
Vault.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-03 : 17:45:57
CVS

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


Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-03 : 17:56:03
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

22859 Posts

Posted - 2006-02-04 : 06:33:31
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
Go to Top of Page

mmarovic
Aged Yak Warrior

518 Posts

Posted - 2006-02-04 : 06:50:43
Subversion + Tortoise.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-02-04 : 07:11:32
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

4149 Posts

Posted - 2006-02-04 : 09:13:34
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

198 Posts

Posted - 2006-02-15 : 09:58:56
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

22859 Posts

Posted - 2007-01-08 : 22:22:53
See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63148
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2011-11-16 : 06:02:08
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

159 Posts

Posted - 2011-11-16 : 06:14:00
Sourcegear Vault
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-11-16 : 13:43:36
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

518 Posts

Posted - 2011-11-17 : 04:35:35
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
   

- Advertisement -