Red Gate forums :: View topic - Environments and Branching
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

Environments and Branching

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



Joined: 19 Oct 2011
Posts: 2

PostPosted: Wed Oct 19, 2011 12:40 am    Post subject: Environments and Branching Reply with quote

Hi, I'm very interested in purchasing the RedGate source control product for my development team. However, I'm struggling on formulating a strategy for managing environments and branches.

We basically have Dev, Test, QA, Staging, and Prod environments. We already have TFS but I'm especially interested in RedGate source control because it appears very easy to use and it integrates well with SSMS.

What do most users commonly do to manage their environments?

My initial thoughts were that we'd have Staging be the main trunk while Dev, Test, and QA would all be branches. As changes move from Dev to Test then we'd merge the specific changesets.

Does this sound like the right approach?
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 594

PostPosted: Fri Oct 21, 2011 10:39 am    Post subject: Reply with quote

Basically, you need a separate folder in TFS for each database. To merge changes from one step to another, you could use SQL Compare directly between the DBs and then commit all the updates back in rather than doing it through TFS and a Get Latest, as it'll handle all the dependencies correctly etc.
Back to top
View user's profile Send private message
robert_biddle



Joined: 19 Oct 2011
Posts: 2

PostPosted: Sat Oct 22, 2011 1:55 am    Post subject: Reply with quote

I think that should work out quite well. I used to do something similar with Schema Compare in TFS between DB Projects but there were some occasional issues. I'll give it a try. Thanks!
Back to top
View user's profile Send private message
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