Conclusion - Migrating to SQL Server 2005

Migrating to SQL Server 2005 is a straightforward process with the Copy Database Wizard, and it will be a common selection for most DBAs when migrating a database and its dependent objects.

Here are more resources for migrating to SQL Server 2005:

Migrating to SQL Server 2005 is a straightforward process with the Copy Database Wizard, and it will be a common selection for most DBAs when migrating a database and its dependent objects. This point-and-click interface is beneficial to successfully complete the migration process without having to code or script out particular objects. If you have a more complex environment and require more flexibility, review the other options from the tip and webcast in the additional resources list above. Good luck!


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