Transition plans for SQL server

Transition plans for SQL server

Post by Tom Stevns Niels » Sat, 12 Jan 2002 23:17:54



If anyone has some knowledge about transitioning the SQL-server
between Prod and Test/Test and Prod then please give me some hints
about it.

Thanx in advance

Tom Stevns Nielsen

 
 
 

Transition plans for SQL server

Post by Dan Guzma » Mon, 14 Jan 2002 03:39:44


I suggest you implement production database changes with tested SQL
scripts.  One method to test your upgrade scripts is to restore your
Prod database to Test and run your scripts.  You can do this iteratively
until you are satisfied with the results.  Then run the same scripts (in
the same order) on the Prod database, taking a Prod backup beforehand as
a precaution.

Depending on the critically of the app, you might consider establishing
separate environments for development (Dev), system testing (QA), user
acceptance testing (UAT) and production (Prod).  The QA and Dev systems
would not necessarily need to be full copies of Prod but the schema in
QA should be the same as Prod before the upgrade scripts are run.

In this scenario, the process is:

1)  develop and test scripts in Dev
2)  run scripts in QA for iterative testing
3)  restore UAT from Prod backup and run scripts
4)  run scripts in Prod

BTW, regardless of the method you choose, I suggest you keep your DDL
scripts under source control.

Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy  Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------



Quote:> If anyone has some knowledge about transitioning the SQL-server
> between Prod and Test/Test and Prod then please give me some hints
> about it.

> Thanx in advance

> Tom Stevns Nielsen