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? Will applications break as a result of the upgrade? This learning guide will help answer these questions and many more so you may be the SQL Server upgrade hero in your customers' eyes.
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.