Determine what hardware is available for both testing and production. Be sure that the hardware is under warranty and will support the users and business for a specified period of time. In addition, be sure the licensing has been acquired to support the environment and includes the correct edition of SQL Server Express, Workgroup, Standard or Enterprise.
For the functional testing environment, make sure test systems match future production systems from a software perspective (i.e., same versions of SQL Server and Windows). When load testing is required, be sure systems are as close as possible to validate that the transactions per second, memory and CPU usage, as well as the disk I/O, are acceptable.
For the production environment, apply the needed Windows and SQL Server service packs and patches in advance to minimize the downtime needed to perform the migration.
Upgrading to SQL Server 2005 using Copy Database Wizard
Step 1: Plan your migration
Step 2: Choose your hardware and software
Step 3: Test your migration process
Step 4: Be sure you have a corruption-free environment
Step 5: Migrate using the Copy Database Wizard
Step 6: Perform post-upgrade tasks
Step 7: Conclusion
|ABOUT THE AUTHOR:|
| Jeremy Kadlec
Jeremy Kadlec is the principal database engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server users groups and nationally at SQL PASS. Kadlec is the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget