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.