Exclusive Table Checkouts / Table Locking

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

Exclusive Table Checkouts / Table Locking

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


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.

Posts: 1
Joined: Tue May 31, 2011 4:33 am
Location: Brisbane, Australia

Postby james.billings » Tue May 31, 2011 3: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.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests