Depends on the complexity of the project. For my simple projects that are non-critical, I generally set up the logins on the new server, backup the database on test, restore in production, recover orphan sql accounts, and do any sql agent or linked server things that need to be implemented.
For more complex and critical systems, given a well funded customer, I like to do a mock upgrade so we can get the sequence of events down and minimize any downtime. It also helps to remove stress from the developing team to have a success under their belts.
Now formal Change control from an organizational perspective is worthy of a book or something. I am just outlining the DBA mechanics here!
Edited by - jamyer on 12/28/2001 1:26:04 PM