Mixing development models

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

Mixing development models

Postby icon » Wed Jun 08, 2011 5:06 am

Hi there,

I'm just wondering if it's possible to mix the development models:

Team A:
dedicated databases for a,b,c (as these are what they are working on directly)
shared d, e,f (shared model - as they are not actively developing here but need access/read)

Team B:
shared a,b,c
dedicated d,e,f

Is this possible or is it a case of run everything locally or nothing locally?
icon
 
Posts: 2
Joined: Wed Jun 08, 2011 5:00 am

Postby james.billings » Fri Jun 10, 2011 9:18 am

I don't believe this is something we'd support. Although the tool won't physically stop you doing it, you may find it doesn't function well. Specifically, the shared mode assumes you're always on the latest, so the Get Latest tab doesn't offer the ability to grab the latest changes from your Source Control system - so the changes developers on Dedicate mode made would not be as simple to get into the shared model database.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby icon » Mon Jun 13, 2011 7:48 am

okay - so in this scenario, where there are 30-40 databases that are not required all the time for each developer but using the dedicated model, what is the recommended solution? I guess developers for each project run locally and then deploy from source control to a central development database server once a day or so? is this the best option?
icon
 
Posts: 2
Joined: Wed Jun 08, 2011 5:00 am

Postby james.billings » Thu Jun 16, 2011 4:10 pm

Yeah, if you have a central dev server with all databases on it, then each dev could "get latest" down to their local instance when they need to work on it, and commit the changes back again when they are done.
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 1 guest