Red Gate forums :: View topic - single shared database mode
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

single shared database mode

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
d.roberts



Joined: 13 Sep 2010
Posts: 8

PostPosted: Mon Oct 11, 2010 11:54 am    Post subject: single shared database mode Reply with quote

I have some suspicions that whilst working in this mode, and I know its not recommended but it works best for us, that some users might be doing a getlatest and potentially overwriting teh changes that other users have made but not yet checked in.

Firstly, is this possible? (maybe when a new user links to an existing TFS controlled db?)
secondly, can GetLatest be disabled for shared db mode (apart from maybe an admin user?)
Back to top
View user's profile Send private message
d.roberts



Joined: 13 Sep 2010
Posts: 8

PostPosted: Mon Oct 11, 2010 3:01 pm    Post subject: additional question about this mode of use Reply with quote

SSC is stating that one of the differences is a conflict.

I'd like tounderstand how SSC can determine this if we are using a shared db model?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Tue Oct 12, 2010 1:58 pm    Post subject: Reply with quote

Thank you for your post into the forum.

When using the shared db model you increase the chance of conflicts in the manner that you have described.

SQL Source Control supports both methods, dedicated and shared but we (Red Gate) recommend the dedicated model as this greatly reduces the known problems using the shared model.

This Knowledge Base article explains the Database Development Models.

I hope this helps to answer your questions.

This second knowledge base article explains Conflict resolution.
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
d.roberts



Joined: 13 Sep 2010
Posts: 8

PostPosted: Wed Oct 13, 2010 9:32 am    Post subject: Reply with quote

The article with detail of the shared model limitations is useful, especially as it hints at your use of a local copy of the scripts (on each dev pc, even in shared db mode) to determine changes and conflicts.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Wed Oct 13, 2010 10:06 am    Post subject: Reply with quote

We hope to improve the usability of the shared model in a later release, with information in the commit list on who made which change, and maybe a warning if you try to commit a change you may not have made yourself.

At some point we hope to avoid the spurious conflicts, but for now, they can simply be ignored and 'keep mine' selected.

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group