Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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.

• 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.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
SQL2005UpgradeTechRef.doc SHA1: ff71b494cc78e6b411d67f25bc6b680161217bfc	4.72 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Microsoft Word

• Click the Download button on this page to download the Word document to a folder on your computer.