TFS Source Control best practises


We are new to DB source control but I have a question along the same lines as the discussion here:

I dont think the question was answered. As mentioned by lowerider, you can have different developers at different checkpoints.

For e.g.:
DEV Database
Developer 1 - working on a l/t project and is checking in data schemas/objects in TFS in a branch labelled: 'LT'
Developer 2 - needs a tactical fix.

Here's my understanding of how this should work
1. Dev 2 check out production branch and applies to DEV.
2. Makes changes and tests his code.
3. Commits to PROD branch when ready.
4. PROD db pulls that branch and applies.
5. Dev 1 checks out his original 'LT' branch and reapplies in DEV and continues his work.

However, in Redgate Tools, Get Latest says 'current version is always uptodate' and migration tab seems to compare DB to the leaf node of the main branch of TFS (?). How can migrations tab compare to a specific labelled node?

Am I thinking about this the wrong way? Should we move to a dedicated model even though we share a database?


Sign In or Register to comment.