ok, So lets start by saying I've been around the block a bit, but still, as of yet, dont have what I would consider a perfect solution to meeting the needs of Data Architects AND QA folks with regards to Builds and deploying to test environments.
The process I typically use to deploy a given build to Environment X is to FIRST Replace All DBs in "X" with Baselines that mimic current production.
AFTER That has been done, THEN run the deployment scripts in the correct order and BAM deployment done.
The problem is, that QA SCREAMS then when I blow away their db with my baseline, they lose all their test data.
we've gone round and round and round and still dont really have a great solution.
anyone with the magic bullet ?
Gregory A Jackson MBA, CSM