can any explain how the work flows from development, staging and Production with diagrams.
asked
I need the workflow process for staging, development and Production database
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 --
| |
|_______|
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
