Microsoft SQL Server 2005 Upgrade Advisor

Select Language:
Download the April 2006 version of Microsoft SQL Server 2005 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 to help you prepare for upgrades to SQL Server 2005.
  • Version:


    File Name:


    Date Published:


    File Size:

    4.1 MB

      Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.
  • Supported Operating System

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

      • The Microsoft .NET Framework 2.0. This is the same version of the .NET Framework that is included with SQL Server 2005 and Visual Studio 2005.
      • SQL Server 2000 Decision Support Objects (DSO) if you are analyzing Analysis Services. You can install DSO from SQL Server 2000 Setup.
      • SQL Server 2000 client components if you are analyzing Data Transformation Services. You can install the client components from SQL Server 2000 Setup.
      • Pentium III-compatible processor or higher, with a processor speed of at least 500 MHz.
      • 15 MB of available hard disk space.

      • Step 1: Use Add or Remove Programs to remove any previous versions of Upgrade Advisor.

        Step 2: For 32-bit platforms, download and install the 32-bit version of Microsoft .NET Framework 2.0. For 64-bit platforms (X64 and EMT64 only), download and install the 64-bit version of Microsoft .NET Framework 2.0.

        Note: If you have already installed SQL Server 2005, you already have Microsoft .NET Framework 2.0.

        Step 3: Click Download. The readme file and documentation are installed with Upgrade Advisor.

      • Upgrade Advisor does not change any configuration settings or data.

      • Upgrade Advisor can analyze remote instances of SQL Server, except for SQL Server 2000 Reporting Services. To analyze Reporting Services, Upgrade Advisor must be installed on the report server.

      • Upgrade Advisor provides the UpgradeAdvisorWizardCmd command-prompt utility to help you more easily scan multiple instances of SQL Server. See the Upgrade Advisor documentation for additional information.

      • Uninstalling Upgrade Advisor requires the .NET Framework 2.0. Uninstall Upgrade Advisor before uninstalling the .NET Framework 2.0

      • If you have questions or comments about Upgrade Advisor, go to the SQL Server Setup & Upgrade Forum.