Servers

    SQL Server 2005 Upgrade Technical Reference Guide

    Language:
    English
    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.
    • Details
      Version:

      1

      File Name:

      SQL2005UpgradeTechRef.doc

      Date Published:

      6/8/2006

      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 System

      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial