Many questions must be answered before upgrading a customer from an older version of Microsoft SQL Server to SQL Server 2005. How should you perform the upgrade? Is the the right hardware and software in place?
Plannning a Microsoft SQL Server upgrade
- Adopting SQL Server 2005
Make a compelling case to enhance a customer's SQL Server environment by upgrading to SQL Server 2005.
- Database components to upgrade to SQL Server 2005
Consider how you can best support your customer's business by upgrading specific database components to SQL Server 2005.
- Requirements for upgrading to SQL Server 2005
- Common SQL Server 2005 migration methods
In-place upgrade and Copy Database Wizard are just two of the various migration methods you may employ when upgrading a customer's database environment to SQL Server 2005.
- Migrating to SQL Server 2005 with Copy Database Wizard
The Copy Database Wizard offers a point-and-click interface to easily migrate a single SQL Server database and its objects from SQL Server 2000 to 2005. Edgewood Solutions' Jeremy Kadlec explains how in this step-by-step guide.
Prepare for a SQL Server 2005 upgrade, from determining the product version upgrade path to meeting hardware and software requirements.
Troubleshooting for SQL Server 2005
- SQL Server 2005 upgrade challenges
Upgrading from older SQL Server versions to SQL Server 2005 may not be so straightforward. This tip outlines some SQL Server 2005 upgrade challenges.
- Red flag upgrade issues with SQL Server 2005 Upgrade Advisor
Microsoft's SQL Server 2005 Upgrade Advisor will give you fair warning of potential SQL Server upgrade problems.
- Backward compatibility issues when upgrading to SQL Server 2005
Do you fear apps will break if you switch a customer to SQL Server 2005? Get help addressing key backward compatibility considerations.
This was first published in February 2007