question

savibp avatar image
savibp asked

I need the workflow process for staging, development and Production database

can any explain how the work flows from development, staging and Production with diagrams.

sql-server-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TG avatar image
TG answered

This is the way it works in our company ;-)

 _______            
|       |            
|       |            
| Dev   | <--            
|       |   |            
|_______|   |            
   |        |            
   |        |            
  \/        |            
            |b            
 _______    |a            
|       |   |c            
|       |   |k            
| stag  |   |            
|       |   |t            
|_______|   |o            
   |        |            
   |        |d            
  \/        |r            
            |a            
 _______    |w            
|       |   |i            
|       |   |n            
| prod  |   |g            
|       |   |            
|_______|   |b            
   |        |o            
   |        |a            
  \/        |r            
            |d            
 _______    |            
|       |   |            
|customers  |            
|complains --            
|       |            
|_______|            
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
Check out the Red Gate Guide to SQL Server [Team-Based Development][1]. It has a whole section on deployment processes that I wrote. [1]: http://www.amazon.com/Gate-Guide-Server-Team-based-Development/dp/190643459X/ref=sr_1_2?ie=UTF8&qid=1309173994&sr=8-2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.