Step 1: Plan your migration First and foremost, build a plan that outlines the logistics for the project. It should include items like dates, times, systems, team members and so on. Make sure the plan outlines all of the major steps in the project from the requirements to the deployment. Incorporate a rollback plan into the overall plan to ensure the SQL Server 2000 environment can be used if a problem occurs in the migration process.
For more SQL Server 2005 migration planning resources, check out:
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