Vendor Management Strategies for the CIOMany 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?
Requires Membership to View
To gain access to this and all member only content, please provide the following information:
By submitting your registration information to SearchSystemsChannel.com you agree to receive email communications from the TechTarget network of sites, and/or third party content providers that have relationships with TechTarget, based on your topic interests and activity, including updates on new content, event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile, unsubscribing via email or by contacting us here
- Your use of SearchSystemsChannel.com is governed by our Terms of Use
- We designed our Privacy Policy to provide you with important disclosures about how we collect and use your registration and other information. We encourage you to read the Privacy Policy, and to use it to help make informed decisions.
- If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States.
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.
This was first published in February 2007