| title | Supported Version and Edition Upgrades | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 2016-08-24 | ||||
| ms.prod | sql-server-2016 | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | article | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 702359c4-6ca9-42a8-860c-a95a802898a1 | ||||
| caps.latest.revision | 148 | ||||
| ms.author | mikeray | ||||
| manager | jhubbard |
You can upgrade from [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], [!INCLUDEssSQL11], and [!INCLUDEssSQL14]. This topic lists the supported upgrade paths from these [!INCLUDEssNoVersion] versions, and the supported edition upgrades for [!INCLUDEssCurrent].
-
Before upgrading from one edition of [!INCLUDEssCurrent] to another, verify that the functionality you are currently using is supported in the edition to which you are moving.
-
Before upgrading [!INCLUDEssNoVersion], enable Windows Authentication for [!INCLUDEssNoVersion] Agent and verify the default configuration: that the [!INCLUDEssNoVersion] Agent service account is a member of the [!INCLUDEssNoVersion] sysadmin group.
-
To upgrade to [!INCLUDEssCurrent], you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server 2016.
-
Upgrade will be blocked if there is a pending restart.
-
Upgrade will be blocked if the Windows Installer service is not running.
-
Cross-version instances of [!INCLUDEssCurrent] are not supported. Version numbers of the [!INCLUDEssDE], [!INCLUDEssASnoversion], and [!INCLUDEssRSnoversion] components must be the same in an instance of [!INCLUDEssCurrent].
-
SQL Server 2016 is only available for 64-bit platforms. Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of [!INCLUDEssNoVersion] to native 64-bit using [!INCLUDEssNoVersion] Setup. However, you can back up or detach databases from a 32-bit instance of [!INCLUDEssNoVersion], and then restore or attach them to a new instance of [!INCLUDEssNoVersion] (64-bit) if the databases are not published in replication. You must re-create any logins and other user objects in master, msdb, and model system databases.
-
You cannot add new features during the upgrade of your existing instance of [!INCLUDEssNoVersion]. After you upgrade an instance of [!INCLUDEssNoVersion] to [!INCLUDEssCurrent], you can add features by using the [!INCLUDEssCurrent] Setup. For more information, see Add Features to an Instance of SQL Server 2016 (Setup).
-
Failover Clusters are not supported in WOW mode.
-
Upgrade from an Evaluation edition of a previous [!INCLUDEssNoVersion] version is not supported.
-
When upgrading from RC1 or previous versions of SQL Server 2016 to RC3 or later versions, PolyBase must be uninstalled before the upgrade and reinstalled after the upgrade.
Upgrades from Earlier Versions to [!INCLUDEssCurrent]
SQL Server 2016 supports upgrade from the following versions of SQL Server:
- SQL Server 2008 SP3 or later
- SQL Server 2008 R2 SP2 or later
- SQL Server 2012 SP2 or later
- SQL Server 2014 or later
Note
To upgrade databases on [!INCLUDEssVersion2005] see Support for 2005.
The table below lists the supported upgrade scenarios from earlier versions of [!INCLUDEssNoVersion] to [!INCLUDEssCurrent].
| Upgrade from | Supported upgrade path |
|---|---|
| [!INCLUDEssKatmai] SP3 Enterprise | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssKatmai] SP3 Developer | [!INCLUDEssCurrent] Developer |
| [!INCLUDEssKatmai] SP3 Standard | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKatmai] SP3 Small Business | [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKatmai] SP3 Web | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web |
| [!INCLUDEssKatmai] SP3 Workgroup | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKatmai] SP3 Express | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Express |
| [!INCLUDEssKilimanjaro] SP2 Datacenter | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssKilimanjaro] SP2 Enterprise | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssKilimanjaro] SP2 Developer | [!INCLUDEssCurrent] Developer |
| [!INCLUDEssKilimanjaro] SP2 Small Business | [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKilimanjaro] SP2 Standard | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKilimanjaro] SP2 Web | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web |
| [!INCLUDEssKilimanjaro] SP2 Workgroup | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssKilimanjaro] SP2 Express | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Express |
| [!INCLUDEssSQL11] SP2 Enterprise | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL11] SP2 Developer | [!INCLUDEssCurrent] Developer [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL11] SP2 Standard | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssSQL11] SP1 Web | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web |
| [!INCLUDEssSQL11] SP2 Express | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Express |
| [!INCLUDEssSQL11] SP2 Business Intelligence | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL11] SP2 Evaluation | [!INCLUDEssCurrent] Evaluation [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Developer |
| [!INCLUDEssSQL14] Enterprise | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL14] Developer | [!INCLUDEssCurrent] Developer [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL14] Standard | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard |
| [!INCLUDEssSQL14] Web | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web |
| [!INCLUDEssSQL14] Express | [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Express [!INCLUDEssCurrent] Developer |
| [!INCLUDEssSQL14] Business Intelligence | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL14] Evaluation | [!INCLUDEssCurrent] Evaluation [!INCLUDEssCurrent] Enterprise [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Developer |
| [!INCLUDEssSQL15_md] release candidate* | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssSQL15_md] Developer | [!INCLUDEssCurrent] Enterprise |
* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Technology Adoption Program (TAP).
[!INCLUDEssCurrent] Support for [!INCLUDEssVersion2005]
This section discusses [!INCLUDEssCurrent] support for [!INCLUDEssVersion2005]. In [!INCLUDEssCurrent], you will be able to do the following:
-
Attach a [!INCLUDEssVersion2005] database (mdf/ldf files) to [!INCLUDEssCurrent] instance of database engine.
-
Restore a [!INCLUDEssVersion2005] database to [!INCLUDEssCurrent] instance of database engine from a backup.
-
Back up a [!INCLUDEssASversion2005] cube and restoring on [!INCLUDEssCurrent].
When a [!INCLUDEssVersion2005] database is upgraded to [!INCLUDEssCurrent], the database compatibility level will be changed from 90 to 100. (In [!INCLUDEssCurrent], valid values for the database compatibility level are 100, 110, 120, and 130.) ALTER DATABASE Compatibility Level (Transact-SQL) discusses how the compatibility level change could affect [!INCLUDEssNoVersion] applications.
Any scenarios not specified in the list above are not supported, including but not limited to the following:
-
Installing [!INCLUDEssVersion2005] and [!INCLUDEssCurrent] on same computer (side by side).
-
Using a [!INCLUDEssVersion2005] instance as a member of the replication topology that involves a [!INCLUDEssCurrent] instance.
-
Configuring database mirroring between [!INCLUDEssCurrent] and [!INCLUDEssVersion2005] instances.
-
Backing up the transaction log with log shipping between [!INCLUDEssCurrent] and [!INCLUDEssVersion2005] instances.
-
Configuring linked servers between [!INCLUDEssCurrent] and [!INCLUDEssVersion2005] instances.
-
Managing a [!INCLUDEssVersion2005] instance from a [!INCLUDEssCurrent] Management Studio.
-
Attaching a [!INCLUDEssASversion2005] cube in [!INCLUDEssCurrent] Management Studio.
-
Connecting to [!INCLUDEssISversion2005] from [!INCLUDEssCurrent] Management Studio.
-
Managing a [!INCLUDEssISversion2005] service from [!INCLUDEssCurrent] Management Studio.
-
Support for [!INCLUDEssVersion2005] third party custom Integration Services components, such as execute and upgrade.
[!INCLUDEssCurrent] Edition Upgrade
The following table lists the supported edition upgrade scenarios in [!INCLUDEssCurrent].
For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server 2016 (Setup).
| Upgrade From | Upgrade To |
|---|---|
| [!INCLUDEssCurrent] Enterprise (Server+CAL and Core)** | [!INCLUDEssCurrent] Enterprise |
| [!INCLUDEssCurrent] Evaluation Enterprise** | [!INCLUDEssCurrent] Enterprise (Server+CAL or Core License) [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Developer [!INCLUDEssCurrent] Web Upgrading from Evaluation (a free edition) to any of the paid editions is supported for stand-alone installations, but is not supported for clustered installations. |
| [!INCLUDEssCurrent] Standard** | [!INCLUDEssCurrent] Enterprise (Server+CAL or Core License) |
| [!INCLUDEssCurrent] Developer** | [!INCLUDEssCurrent] Enterprise (Server+CAL or Core License) [!INCLUDEssCurrent] Web [!INCLUDEssCurrent] Standard |
| [!INCLUDEssCurrent] Web | [!INCLUDEssCurrent] Enterprise (Server+CAL or Core License) [!INCLUDEssCurrent] Standard |
| [!INCLUDEssCurrent] Express* | [!INCLUDEssCurrent] Enterprise (Server+CAL or Core License) [!INCLUDEssCurrent] Developer [!INCLUDEssCurrent] Standard [!INCLUDEssCurrent] Web |
Additionally you can also perform an edition upgrade between [!INCLUDEssCurrent] Enterprise (Server+CAL license) and [!INCLUDEssCurrent] Enterprise (Core License):
| Edition Upgrade From | Edition Upgrade To |
|---|---|
| [!INCLUDEssCurrent] Enterprise (Server+CAL License)** | [!INCLUDEssCurrent] Enterprise (Core License) |
| [!INCLUDEssCurrent] Enterprise (Core License) | [!INCLUDEssCurrent] Enterprise (Server+CAL License) |
* Also applies to [!INCLUDEssCurrent] Express with Tools and [!INCLUDEssCurrent] Express with Advanced Services.
** Changing the edition of a [!INCLUDEssCurrent] failover cluster is limited. The following scenarios are not supported for [!INCLUDEssCurrent] failover clusters:
-
[!INCLUDEssCurrent] Enterprise to [!INCLUDEssCurrent] Developer, Standard, or Evaluation.
-
[!INCLUDEssCurrent] Developer to [!INCLUDEssCurrent] Standard or Evaluation.
-
[!INCLUDEssCurrent] Standard to [!INCLUDEssCurrent] Evaluation.
-
[!INCLUDEssCurrent] Evaluation to [!INCLUDEssCurrent] Standard.
Editions and Supported Features for SQL Server 2016
Hardware and Software Requirements for Installing SQL Server 2016