Ladies and gentleman, start your engines! With all of the new features in SQL Server 2005, the race is on and adoption is in full swing. Many organizations are leveraging these features to ease current issues or gain competitive advantage in the marketplace. So how are DBAs accomplishing this task? In this tip I will outline technical options to consider when migrating to SQL Server 2005.
Migrating to SQL Server 2005
Step 1: What to upgrade
Step 2: Upgrade prerequisites
Step 3: Migration options
Step 4: Additional considerations
ABOUT THE AUTHOR:
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. Jeremy is also SearchSQLServer.com's Performance Tuning expert.
More information from SearchSQLServer.com
- Tip: Reduce upgrade unknowns with SQL Server 2005 Upgrade Advisor
- Learning Guide: SQL Server 2005 Learning Guide
- Book Excerpts: SQL Server 2005 Management Studio
This was first published in March 2006