Exclusive Table Checkouts / Table Locking

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

Exclusive Table Checkouts / Table Locking

Postby craigsdc » Tue May 31, 2011 5:47 am

Hi,

We currently using the Shared Database Development model, and have a quick question regarding sql source control on development machines.

Is it possible to do exclusive checkout of tables at all?

Meaning, if user X makes a change to a table, it auto checks out the table and user Y cannot make changes to that table until user X checks in the changes.

Currently we have SQL Source control on the server only, and not on our development machines.. If it is installed on our development machines will SSMS detect that use X has made changes, and not allow user Y to modify it at all.

Thanks,
Craig
craigsdc
 
Posts: 1
Joined: Tue May 31, 2011 5:33 am
Location: Brisbane, Australia

Postby james.billings » Tue May 31, 2011 4:08 pm

Currently, SQL Source Control doesn't perform the locking checkouts you refer to - please check this suggestion on our uservoice: http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/802123-tfs-exclusive-checkout-svn-lock?ref=title where you can add your own comments and votes.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron