Preparing for a Smooth Upgrade SQL Server 2005

Content Summary : To meet a new generation of data-management needs, Microsoft SQL Server 2005 has been reworked extensively to enhance performance and application programmability. Originally published by SQL Server Magazine as part of its "SQL Server 2005 UpgradeHandbook," this article explores how administrators can help ensure a successful transition to SQL Server 2005 by planning, testing, and using the Upgrade Advisor. Each Microsoft SQL Server 2005 component is designed to have a unique architecture and life cycle—the two primary areas that can affect an upgrade path. Some SQLServer 2005 components build on a solid foundation to augment, optimize, and help stabilize existing functionality. Microsoft has performed an extensive reworking of other SQL Server features to enhance performance and application programmability. SQL Server 2005 also incorporates completely overhauled components and additions designed to meet a new generation of data management needs. Preparing for a SQL Server 2005 upgrade involves understanding some basic principles that enable administrators to make appropriate decisions and help ensure success. As with any upgrade, the keys to success are appropriate planning and testing for the needs of the specific environment. This article explores the overall upgrade path for SQL Server 2005 components and how the SQL Server 2005 Upgrade Advisor tool can help identify areas that require special attention. Specific upgrade considerations for certain SQL Server 2005components—the database engine, Integration Services, Analysis Services, and Reporting Services—are also examined.

Download File