option to lock objects instead of creating new versions
Using TFS as source control, when more than one person is working on the same object (procedure) it causes multiple files to be created. Would like an option to resolve conflicts instead of creating additional versions in the source control.
Please contact support@red-gate.com if you have this problem.
-
Did the 2 files differ in case?
Would you be able to email support@red-gate.com the files so we coudl review?
-
Emmanuel Tiglao commented
I'm not sure how we were able to generate multiple versions either, but the end result after committing changes for a procedure (sp_sample) with changes, I ended up in the source control having two scripts named sp_sample.sql and sp_sample1.sql
-
David Atkinson commented
I'm not sure I understand how you've created multiple files. If two people create the same object, the first one to commit will 'win'. Subsequent commit attempts should appear as conflicts, requiring the user to "keep mine" or "take theirs". Or maybe you've found a serious bug, in which case we'd definitely want to know about this.