Although the migration process is straightforward with the Copy Database Wizard, the process and applications should be thoroughly tested. The first test should occur in the SQL Server 2000 environment by reviewing the results you get from running the SQL Server 2005 Upgrade Advisor. This free tool from Microsoft will outline any problem areas you must address prior to the upgrade.
Validating the SQL Server 2000 environment should be followed by testing the migration process. To save time, document the process as you proceed to ensure subsequent migrations are performed in the same manner.
Finally, build and execute test plans for business applications to validate that the application is behaving as expected. Also document this process as test changes are committed and during the migration. Review the testing process to determine if it can be automated. One quick option is to use Profiler to capture all of the commands issued by the application and compare the commands issued by the application to the steps performed by the testers.
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