Step 3: Test your migration process

Migrating to SQL Server 2005 is straightforward with the Copy Database Wizard, but the process and applications should be thoroughly tested as detailed in this Step-by-Step Guide.

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
 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


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
This was last published in June 2006

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.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close