SQL Server 2005 Upgrade Technical Reference Guide

Brief Description

This 350-page document contains guidance for SQL Server administrators, developers, and IT decision makers who would like to move their SQL Server 2000 or 7.0 databases to SQL Server 2005.

Overview

SQL Server 2005 offers many new possibilities and opportunities for SQL Server administrators, developers, and IT decision makers. But to make use of the new features found in SQL Server 2005, companies must first upgrade their existing database environments.

This document contains guidance for SQL Server administrators, developers, and IT decision makers who want to move their SQL Server 2000 or 7.0 databases to SQL Server 2005. The primary purposes of this document are threefold:

Increase confidence and reduce uncertainty about upgrading previous versions of SQL Server to SQL Server 2005.
Lower upgrade risks by providing prescriptive, best-practices technical guidance about how to upgrade specific SQL Server features across all editions.
Provide Microsoft partners and field representatives with appropriate SQL Server 2005 upgrade resources to serve customers.

Section 1.0, “Upgrade Planning and Deployment,” provides a comprehensive overview of the key planning and deployment considerations for upgrading to SQL Server 2005.
Sections 2.01-2.05 cover special upgrade considerations for high availability and very large databases (VLDB).
Sections 3.01-3.08 cover upgrading relational databases to SQL Server 2005, including specific discussions on security, Transact-SQL queries, full-text catalogs, maintenance plans and SQL Server Agent jobs, Notification Services, Management Tools, and MSDE.
Sections 4.01-4.03 then cover moving to the SQL Server 2005 business intelligence components: Reporting Services, Integration Services, and Analysis Services.

See the appendices for detailed feature and edition comparisons and highlighted upgrade tips and tricks.

Top of page