Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2005
 Version and Edition Upgrades

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
Version and Edition Upgrades

Updated: 15 September 2007

The following upgrade scenarios are supported in this release of SQL Server 2005:

Upgrade from Supported Upgrade Paths

SQL Server 7.0 Enterprise Edition SP4

SQL Server 2005 Enterprise Edition

SQL Server 7.0 Developer Edition SP4

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 7.0 Standard Edition SP4

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

SQL Server 7.0 Desktop Edition SP4

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 7.0 Evaluation Edition SP4

Upgrades not supported

SQL Server Desktop Engine (MSDE) 7.0 SP4

SQL Server 2005 Express Edition

SQL Server 2000 Enterprise Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2000 Developer Edition SP3 or later1

SQL Server 2005 Developer Edition

SQL Server 2000 Standard Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2000 Workgroup Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2000 Personal Edition SP3 or later1

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2000 Evaluation Edition SP3 or later1

SQL Server 2005 Evaluation Edition

SQL Server Desktop Engine (MSDE) 2000 SP3 or later1

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2000 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2000 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 Developer Edition 1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Standard Edition1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Workgroup Edition1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Evaluation Edition1,2

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition 1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2005 Express Edition with Advanced Services¹

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Standard Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Evaluation Edition2

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Evaluation Edition2

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Standard Edition

1This SQL Server edition can be upgraded to SQL Server 2005 on the 32-bit subsystem (WOW64) of a 64-bit server.

2You can upgrade an instance of SQL Server 2005 Evaluation Edition to any other edition of SQL Server 2005 without uninstalling Evalation Edition. For more information, see Upgrading to SQL Server 2005 and Editions and Components of SQL Server 2005.

Upgrade Notes

  • After upgrading to SQL Server 2005 from another edition of SQL Server 2005, you must re-apply any hotfix or service pack updates to the upgraded SQL Server instance.
  • Cross-version instances on SQL Server 2005 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same within an instance of SQL Server 2005.
  • Before upgrading to SQL Server 2005, enable Windows Authentication for SQL Server Agent and verify that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
  • Before upgrading from one edition of SQL Server 2005 to another, verify that the functionality you are currently using is supported in the edition to which you are upgrading. For more information, see the section for your components in Features Supported by the Editions of SQL Server 2005.
  • To upgrade a SQL Server instance to a SQL Server 2005 failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server 2005 failover cluster, install a new SQL Server 2005 failover cluster and then migrate user databases from the stand-alone instance using the Copy Database Wizard. For more information on upgrade, see How to: Upgrade to a SQL Server 2005 Failover Cluster Instance (Setup). For more information on database migration, see Using the Copy Database Wizard.
  • Upgrading a 32-bit instance of SQL Server 2000 from the 32-bit subsystem (WOW64) of a 64-bit server to SQL Server 2005 (64-bit) on the X64 platform is not supported. However, you can upgrade a 32-bit instance of SQL Server to SQL Server 2005 on the WOW64 of a 64-bit server as noted in the table above. You can also backup or detach databases from a 32-bit instance of SQL Server 2000, and restore or attach them to an instance of SQL Server 2005 (64-bit) if the databases are not published in replication. In this case, you must also recreate any logins and other user objects in master, msdb, and model system databases.

You can add components to an existing installation of SQL Server 2005 from Add or Remove Programs in Control Panel and then select the instance of SQL Server to which you want to add or remove features. For more information, see How to: Change Components in an Existing Instance of SQL Server 2005 (Setup).

For upgrades:

  • English-language versions of SQL Server can be upgraded to any localized version of SQL Server 2005.
  • Localized versions of SQL Server can be upgraded to localized versions of SQL Server 2005 of the same language.
  • Localized version of SQL Server cannot be upgraded to the English-language version of SQL Server 2005.
  • Localized versions of SQL Server cannot be upgraded to localized SQL Server 2005 versions of a different localized language.

Additional cross-language support:

  • The English-language version of SQL Server 2005 is supported on all localized versions of supported operating systems.
  • Localized versions of SQL Server 2005 are supported on localized operating systems that are the same language as the localized SQL Server version.
  • Localized versions of SQL Server 2005 are also supported on English-language versions of supported operating systems through the use of Windows Multilingual User Interface Pack (MUI) settings. However, you must verify certain operating system settings before installing a localized version of SQL Server 2005 on a server that is running an English-language operating system with a non-English MUI setting. You must verify that the following operating system settings match the language of the localized SQL Server to be installed:
    • The operating system user interface setting
    • The operating system user locale setting
    • The system locale setting
    If these operating system settings do not match the language of the localized SQL Server, then you must correctly set these operating system settings as described in How to: Change Operating System Settings to Support Localized Versions.

Release History

15 September 2007

Changed content:
  • Added content about upgrading from SQL Server 2005 Evaluation Edition.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker