Step 2: Choose your hardware and software

In this Step-by-Step Guide learn the components to consider when choosing hardware for your upgrade to SQL Server 2005.

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
 Home: Introduction
 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

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 Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget

Dig Deeper on SQL Server Migration Strategies and Planning

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.