New user questions

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

New user questions

Postby WEdmonds » Mon May 06, 2013 8:33 pm

I have a question about SQL Source Control. We are using your source control product with TFS. There are four people that are developing on our various databases. We are slowly adding databases to source control. Is there any way that I can automatically see what databases other devs have already added to version control?

If dev one adds AdventureWorks database to source control, there seems to be nothing stopping the other three devs from continuing to make changes outside of version control. Is this correct? I thought that adding a database to source control would keep others from being able to make changes without going through committing the changes.
WEdmonds
 
Posts: 1
Joined: Mon May 06, 2013 8:29 pm

Postby chriskelly » Thu May 09, 2013 1:28 pm

Unfortunately, SQL Source Control does not put any kind of lock on the repository to stop users from making changes from outside of the tool. As access is determined by users permissions (which is independent of the tool), I cannot see how this could happen using the current model.

However, I would recommend that you post on the SQL Source Control UserVoice Forum. The development team use this to gather feature ideas and to gauge user interest in them. Please include a brief description of why this would be useful.

http://redgate.uservoice.com/forums/390 ... ce-control
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby David Atkinson » Thu May 09, 2013 4:36 pm

@WEdmonds.

SQL Source Control adopts the Edit-Merge-Commit source control doctrine. This is described in more detail here:

http://www.ericsink.com/scm/scm_checkins.html

This is increasingly popular as a methodology as it doesn't prevent developers from commencing work. The newer DVCS source control systems like GIT and Mercurial are very much based on this philosophy.

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests