Trace Id is missing

Unlock your potential with Microsoft Copilot

Get things done faster and unleash your creativity with the power of AI anywhere you go.
Download the Copilot app
Microsoft Copilot app being utilized to generate pictures of a singing dog, assisting to identify a flower, and helping to generate an email to congratulate a coworker on a promotion.

SQL Server 2005 Upgrade Technical Reference Guide

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.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download

  • Version:

    1

    Date Published:

    6/8/2006

    File Name:

    SQL2005UpgradeTechRef.doc

    File Size:

    6.9 MB

    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.

  • Supported Operating Systems

    Windows 2000 Service Pack 4, Windows Server 2003 Service Pack 1, Windows XP Service Pack 2

    Microsoft Word

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

Follow Microsoft
Back To Top