Version and Edition Upgrades

The following upgrade scenarios are supported in this release of SQL Server 2008 R2.

Upgrade from

Supported upgrade path

SQL Server 2000 (32-Bit) MSDE SP41

SQL Server 2008 R2 Express

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2000 (32-Bit) Workgroup SP41

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2000 (32-Bit) Standard SP41,4

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2000 (32-Bit) Developer SP41,4

SQL Server 2008 R2 Developer

SQL Server 2000 (32-Bit) Enterprise SP41,4

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2000 (32-bit, IA64) Evaluation4,5

No upgrade support.

SQL Server 2000 (64-Bit) IA64 Developer SP43,4,5

SQL Server 2008 R2 (64-Bit) IA64 Developer

SQL Server 2000 (64-Bit) IA64 Enterprise SP43,4,5

SQL Server 2008 R2 (64-Bit) IA64 Enterprise

SQL Server 2008 R2 (64-Bit) IA64 Datacenter

SQL Server 2000 (32-Bit) Personal SP4

No upgrade support.

SQL Server 2005 (32-Bit) Express SP21

SQL Server 2008 R2 Express

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup 

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2005 (32-Bit) Express SP21 Advanced1

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup 

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2005 (32-Bit) Workgroup SP21

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2005 (32-Bit) Standard SP21

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2005 (32-Bit) Developer SP21

SQL Server 2008 R2 Developer

SQL Server 2005 (32-Bit) Enterprise SP21

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2005 (32-bit, IA64, X64) Evaluation SP2

No upgrade support.

SQL Server 2005 IA64 (64-bit) Developer SP2

SQL Server 2008 R2 IA64 (64-bit) Developer

SQL Server 2005 IA64 (64-bit) Standard SP2

SQL Server 2008 R2 IA64 (64-bit) Enterprise

SQL Server 2005 IA64 (64-bit) Enterprise SP2

SQL Server 2008 R2 IA64 (64-bit) Enterprise 

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2005 X64 (64-bit) Developer SP2

SQL Server 2008 R2 X64 (64-bit) Developer

SQL Server 2005 X64 (64-bit) Standard SP2

SQL Server 2008 R2 X64 (64-bit) Standard

SQL Server 2008 R2 X64 (64-bit) Enterprise

SQL Server 2005 X64 (64-bit) Enterprise SP2

SQL Server 2008 R2 X64 (64-bit) Enterprise

SQL Server 2008 R2 X64 (64-bit) Datacenter

SQL Server 2008 Express1

SQL Server 2008 R2 Express

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 Express with Tools

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 Express with Advanced Services1

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 Workgroup1

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 Web1

SQL Server 2008 R2 Web

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2008 Standard1

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 Developer1

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Datacenter

SQL Server 2008 Enterprise1

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 x64 (64-bit) Express

SQL Server 2008 R2 x64 (64-bit) Express

SQL Server 2008 R2 x64 (64-bit) Express with Tools

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Express with Tools

SQL Server 2008 R2 x64 (64-bit) Express with Tools

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Web

SQL Server 2008 R2 x64 (64-bit) Web

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Developer

SQL Server 2008 R2 x64 (64-bit) Developer

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 IA64 (64-bit) Developer

SQL Server 2008 R2 IA64 (64-bit) Developer

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 IA64 (64-bit) Enterprise

SQL Server 2008 R2 IA64 (64-bit) Enterprise 

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 (32-bit, x64 and IA64) Evaluation

No Upgrade Support

SQL Server 2008 R2 Express1

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Express with Tools

SQL Server 2008 R2 Express with Advanced Services

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Express with Advanced Services1

SQL Server 2008 R2 Workgroup

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Workgroup1

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Web1

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Standard1,2

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Developer1,2

SQL Server 2008 R2 Workgroup 

SQL Server 2008 R2 Web6

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Enterprise

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Enterprise1,2

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Evaluation2

SQL Server 2008 R2 Workgroup8

SQL Server 2008 R2 Web8

SQL Server 2008 R2 Standard

SQL Server 2008 R2 Developer

SQL Server 2008 R2 Enterprise 

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Enterprise7

SQL Server 2008 R2 x64 (64-bit) Express

SQL Server 2008 R2 x64 (64-bit) Express with Tools

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit)Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit)Developer

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Express with Tools

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Developer

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Developer

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Web

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Standard2

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Developer2

SQL Server 2008 R2 x64 (64-bit) Workgroup

SQL Server 2008 R2 x64 (64-bit) Web6

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Enterprise2

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Evaluation2

SQL Server 2008 R2 x64 (64-bit) Workgroup8

SQL Server 2008 R2 x64 (64-bit) Web8

SQL Server 2008 R2 x64 (64-bit) Standard

SQL Server 2008 R2 x64 (64-bit) Developer

SQL Server 2008 R2 x64 (64-bit) Enterprise 

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Datacenter

SQL Server 2008 R2 x64 (64-bit) Enterprise7

SQL Server 2008 R2 IA64 (64-bit) Developer2

SQL Server 2008 R2 IA64 (64-bit) Enterprise 

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 R2 IA64 (64-bit) Enterprise2

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 R2 IA64 (64-bit) Evaluation2

SQL Server 2008 R2 IA64 (64-bit) Enterprise

SQL Server 2008 R2 IA64 (64-bit) Developer 

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 R2 IA64 (64-bit) Datacenter

SQL Server 2008 R2 IA64 (64-bit) Enterprise7

1This SQL Server edition can be upgraded to SQL Server 2008 R2 on the 32-bit subsystem (WOW64) of a 64-bit server. Failover Clusters are not supported in the WOW mode. If you currently have SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64) upgrade of the failover cluster to SQL Server 2008 R2 is not supported.

2Changing the edition of a SQL Server 2008 R2 failover cluster is limited. The following edition change scenarios are not supported for SQL Server 2008 R2 failover clusters:

  • SQL Server 2008 R2 Enterprise to SQL Server 2008 R2 Developer, Standard, or Evaluation.

  • SQL Server 2008 R2 Developer to SQL Server 2008 R2 Standard or Evaluation.

  • SQL Server 2008 R2 Standard to SQL Server 2008 R2 Evaluation.

  • SQL Server 2008 R2 Evaluation to SQL Server 2008 R2 Standard.

3Upgrade of SQL Server 2000 (64-Bit) IA64 failover clusters are not supported.

4Upgrade of SQL Server 2000 Analysis Services to SQL Server 2008 R2 is not supported on failover clusters.

5Upgrade of SQL Server 2000 (64-Bit) will not install SQL Server 2008 R2 Management Tools. To install Management Tools, you must re-run Setup after the upgrade is complete. 

6Edition change from SQL Server 2008 R2 Developer to SQL Server 2008 R2 Web is supported only on SQL Server 2008 R2 stand-alone installations.

7Edition change from SQL Server 2008 R2 Datacenter to SQL Server 2008 R2 Enterprise is supported on SQL Server 2008 R2 stand-alone and failover cluster installations.

8If you are upgrading from SQL Server Evaluation to SQL Server Web or SQL Server Workgroup, you must uninstall Analysis Services before you run the edition upgrade.

Upgrade Notes

  • Cross-version instances of SQL Server 2008 R2 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server 2008 R2.

  • Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration: that the SQL Server Agent service account is a member of the SQL Server sysadmin group.

  • Before upgrading from one edition of SQL Server 2008 R2 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 2008 R2.

  • Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit. However, you can upgrade a 32-bit instance of SQL Server to the WOW64: the 32-bit subsystem on a 64-bit server as noted in the table above. You can also back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to an instance of SQL Server (64-bit) if the databases are not published in replication. In this case, you must also re-create any logins and other user objects in master, msdb, and model system databases.

  • To upgrade to SQL Server 2008 R2, you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server 2008 R2.

  • Upgrade will be blocked if there is a pending restart.

  • Upgrade will be blocked if the Windows Installer service is not running.

  • Upgrade will be blocked if performance counters are corrupt.

  • To upgrade an instance of SQL Server to a SQL Server failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server failover cluster, install a new SQL Server failover cluster and then migrate user databases from the stand-alone instance by using the Copy Database Wizard. For more information about upgrade, see How to: Upgrade a SQL Server Failover Cluster Instance (Setup). For more information about database migration, see Using the Copy Database Wizard.

Adding Components to an Instance of SQL Server

You cannot add components to an existing installation of SQL Server at the time you upgrade to SQL Server 2008 R2.After you upgrade an instance of SQL Server to SQL Server 2008 R2, you can add features by using the SQL Server 2008 R2 Installation Wizard: Setup.exe.

Cross-Language Support

For more information about cross-language support and considerations for installing SQL Server in localized languages, see Local Language Versions in SQL Server.