Red Gate forums :: View topic - Dedicated vs. shared development model questions
Return to www.red-gate.com RSS Feed Available

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

Dedicated vs. shared development model questions

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
BobGood



Joined: 25 Mar 2008
Posts: 8

PostPosted: Mon Apr 11, 2011 7:39 pm    Post subject: Dedicated vs. shared development model questions Reply with quote

We are a small development staff responsible for extending a vendor supplied application (and database). We make relatively few changes to the schema, and more changes to static data.
Only 2-3 developers modify schema. Some 10 are application developers who may modify static data using the applications interface (as opposed to SSMS).
Is there a suggestion to configure Sql Source Control 2.1 for shared mode to support most application developers, and dedicated mode for 2 or 3 others?
In shared mode, the events that would trigger a commit are:

  • Application developer request
  • Before and after applying a vendor supplied update
  • Periodically
  • At code freeze

Other question: What is polling about? What does it do? Is it employed in either or both dedicated and shared development model?[/list]
_________________
Bob Good
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Apr 14, 2011 8:18 pm    Post subject: Reply with quote

Hi Bob,

The shared or dedicated model relates to how the developers access SQL Server.

In a dedicated model, each person has a local instance of SQL Server installed in a sandboxed environment.

In a shared model, each developer has SSMS but they each connect to a shared, single instance of SQL Server which hosts the DB.

I guess in your situation, a commit would be triggered automatically when:

1) A developer made a change to the schema in either the sandboxed or shared model
2) If a vendor update applied over your shared or dedicated DB's, you would then be prompted to commit that version
3) When you wanted to add static data, or if static data had been amended either locally or one of the developers dedicated instances

On the subject of polling, this is something that we do within the DB itself to check for changes to objects and to generate the blue blobs by objects that have been modified. It's used in both models.
HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
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