Version and Edition Upgrades

Version and Edition Upgrades

Community Content

In this section

Statistics Annotations (4)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

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.

Reference

Hardware and Software Requirements for Installing SQL Server 2008 R2

Concepts

Planning a SQL Server Installation

Upgrading to SQL Server 2008 R2

Using Upgrade Advisor to Prepare for Upgrades

Tags

: Add a tag

Community Content

Add new content

Annotations

Upgrading from SQL server 2008 R2 workgroup (Boxed 5 user) to standard (MOLP)

Mugoks ... adam finnegan | Edit | Show History

Hello

Problem upgrading from SQL server 2008 R2 workgroup (Boxed 5 user) to standard (MOLP)
SQL server 2008 R2 workgroup (Boxed 5 user) with a licensed number
Upgrade to SQL server 2008 R2 standard MOLP with the ISO file with NO license number
Do i need to Uninstall SQL server 2008 R2 and install again ?

Regards HS

Tags

: Add a tag

Flag as ContentBug

Edition upgrade from 2008 R2 Express to Standard

AgentDraco | Edit | Show History

I'm trying to upgrade from "SQL Server 2008 R2 x64 (64-bit) Express with Advanced Services" to "SQL Server 2008 R2 x64 (64-bit) Standard" edition (with trial license) via Maintenance->Edition Upgrade, but getting a "Edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements." error although the above upgrade path is included in the matrix on this page. Any workarounds?

Thanks.

Tags

: Add a tag

Flag as ContentBug

Upgrade from Microsoft SQL Server 2008 R2 Evaluation Edition to a licensed edition

Alberto Morillo ... adam finnegan | Edit | Show History

Hello,

Learn how to upgrade an instance of SQL Server 2008 R2 Evaluation Edition (that has expired) to a licensed edition without losing any data or any configuration by visiting the following link:

http://www.sqlcoffee.com/Troubleshooting073.htm

Regards,

Alberto Morillo
SQLCoffee.com

Tags

: Add a tag

Flag as ContentBug

Upgrading to SQL server 2008 from an unsupported version

JustJill54 ... adam finnegan | Edit | Show History

I ran the query to find out which version of SQL Server I was using, and I found that I am not upgrading fromone of the supported types in the list above. So how should I be doing the upgrade? Should I just install 2008 as if it is a clean install, connect to it to the db servers I need, and then restore a backup of my local I have created?

Tags

: Add a tag

Flag as ContentBug