| title | Supported Version and Edition Upgrades - SQL Server 2017| Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 07/18/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.prod_service | database-engine | ||||
| ms.service | |||||
| ms.component | install-windows | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | article | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 702359c4-6ca9-42a8-860c-a95a802898a1 | ||||
| caps.latest.revision | 148 | ||||
| author | MikeRayMSFT | ||||
| ms.author | mikeray | ||||
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
You can upgrade from [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], [!INCLUDEssSQL11], [!INCLUDEssSQL14], and [!INCLUDEsssql15-md]. This article lists the supported upgrade paths from these [!INCLUDEssNoVersion] versions, and the supported edition upgrades for [!INCLUDEsssqlv14-md].
-
Before upgrading from one edition of [!INCLUDEsssqlv14-md] 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 [!INCLUDEsssqlv14-md], you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server.
-
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 [!INCLUDEsssqlv14-md] are not supported. Version numbers of the [!INCLUDEssDE], [!INCLUDEssASnoversion], and [!INCLUDEssRSnoversion] components must be the same in an instance of [!INCLUDEsssqlv14-md].
-
[!INCLUDEsssqlv14-md] 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 [!INCLUDEsssqlv14-md], you can add features by using the [!INCLUDEsssqlv14-md] Setup. For more information, see Add Features to an Instance of SQL Server (Setup).
-
Failover Clusters are not supported in WOW mode.
Upgrades from Earlier Versions to [!INCLUDEsssqlv14-md]
[!INCLUDEsssqlv14-md] supports upgrade from the following versions of SQL Server:
- SQL Server 2008 SP4 or later
- SQL Server 2008 R2 SP3 or later
- SQL Server 2012 SP2 or later
- SQL Server 2014 or later
- SQL Server 2016 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 [!INCLUDEsssqlv14-md].
| Upgrade from | Supported upgrade path |
|---|---|
| [!INCLUDEssKatmai] SP4 Enterprise | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssKatmai] SP4 Developer | [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssKatmai] SP4 Standard | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKatmai] SP4 Small Business | [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKatmai] SP4 Web | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
| [!INCLUDEssKatmai] SP4 Workgroup | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKatmai] SP4 Express | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Express |
| [!INCLUDEssKilimanjaro] SP3 Datacenter | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssKilimanjaro] SP3 Enterprise | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssKilimanjaro] SP3 Developer | [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssKilimanjaro] SP3 Small Business | [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKilimanjaro] SP3 Standard | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKilimanjaro] SP3 Web | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
| [!INCLUDEssKilimanjaro] SP3 Workgroup | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssKilimanjaro] SP3 Express | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Express |
| [!INCLUDEssSQL11] SP2 Enterprise | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL11] SP2 Developer | [!INCLUDEsssqlv14-md] Developer [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL11] SP2 Standard | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssSQL11] SP1 Web | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
| [!INCLUDEssSQL11] SP2 Express | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Express |
| [!INCLUDEssSQL11] SP2 Business Intelligence | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL11] SP2 Evaluation | [!INCLUDEsssqlv14-md] Evaluation [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssSQL14] Enterprise | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL14] Developer | [!INCLUDEsssqlv14-md] Developer [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL14] Standard | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssSQL14] Web | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
| [!INCLUDEssSQL14] Express | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Express [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssSQL14] Business Intelligence | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL14] Evaluation | [!INCLUDEsssqlv14-md] Evaluation [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssSQL15] Enterprise | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL15] Developer | [!INCLUDEsssqlv14-md] Developer [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL15] Standard | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEssSQL15] Web | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
| [!INCLUDEssSQL15] Express | [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Express [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEssSQL15] Business Intelligence | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEssSQL15] Evaluation | [!INCLUDEsssqlv14-md] Evaluation [!INCLUDEsssqlv14-md] Enterprise [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Developer |
| [!INCLUDEsssqlv14-md] release candidate* | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEsssqlv14_md] Developer | [!INCLUDEsssqlv14-md] Enterprise |
* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Technology Adoption Program (TAP).
[!INCLUDEsssqlv14-md] Support for [!INCLUDEssVersion2005]
This section discusses [!INCLUDEsssqlv14-md] support for [!INCLUDEssVersion2005]. In [!INCLUDEsssqlv14-md], you will be able to do the following:
-
Attach a [!INCLUDEssVersion2005] database (mdf/ldf files) to [!INCLUDEsssqlv14-md] instance of database engine.
-
Restore a [!INCLUDEssVersion2005] database to [!INCLUDEsssqlv14-md] instance of database engine from a backup.
-
Back up a [!INCLUDEssASversion2005] cube and restore it on [!INCLUDEsssqlv14-md].
When a [!INCLUDEssVersion2005] database is upgraded to [!INCLUDEsssqlv14-md], the database compatibility level will be changed from 90 to 100. (In [!INCLUDEsssqlv14-md], valid values for the database compatibility level are 100, 110, 120, 130, and 140.) 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 [!INCLUDEsssqlv14-md] on same computer (side by side).
-
Using a [!INCLUDEssVersion2005] instance as a member of the replication topology that involves a [!INCLUDEsssqlv14-md] instance.
-
Configuring database mirroring between [!INCLUDEsssqlv14-md] and [!INCLUDEssVersion2005] instances.
-
Backing up the transaction log with log shipping between [!INCLUDEsssqlv14-md] and [!INCLUDEssVersion2005] instances.
-
Configuring linked servers between [!INCLUDEsssqlv14-md] and [!INCLUDEssVersion2005] instances.
-
Managing a [!INCLUDEssVersion2005] instance from a [!INCLUDEsssqlv14-md] Management Studio.
-
Attaching a [!INCLUDEssASversion2005] cube in [!INCLUDEsssqlv14-md] Management Studio.
-
Connecting to [!INCLUDEssISversion2005] from [!INCLUDEsssqlv14-md] Management Studio.
-
Managing a [!INCLUDEssISversion2005] service from [!INCLUDEsssqlv14-md] Management Studio.
-
Support for [!INCLUDEssVersion2005] third party custom Integration Services components, such as execute and upgrade.
[!INCLUDEsssqlv14-md] Edition Upgrade
The following table lists the supported edition upgrade scenarios in [!INCLUDEsssqlv14-md].
For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server (Setup).
| Upgrade From | Upgrade To |
|---|---|
| [!INCLUDEsssqlv14-md] Enterprise (Server+CAL and Core)** | [!INCLUDEsssqlv14-md] Enterprise |
| [!INCLUDEsssqlv14-md] Evaluation Enterprise** | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Developer [!INCLUDEsssqlv14-md] 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. |
| [!INCLUDEsssqlv14-md] Standard** | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL or Core License) |
| [!INCLUDEsssqlv14-md] Developer** | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv14-md] Web [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEsssqlv14-md] Web | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv14-md] Standard |
| [!INCLUDEsssqlv14-md] Express* | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv14-md] Developer [!INCLUDEsssqlv14-md] Standard [!INCLUDEsssqlv14-md] Web |
Additionally you can also perform an edition upgrade between [!INCLUDEsssqlv14-md] Enterprise (Server+CAL license) and [!INCLUDEsssqlv14-md] Enterprise (Core License):
| Edition Upgrade From | Edition Upgrade To |
|---|---|
| [!INCLUDEsssqlv14-md] Enterprise (Server+CAL License)** | [!INCLUDEsssqlv14-md] Enterprise (Core License) |
| [!INCLUDEsssqlv14-md] Enterprise (Core License) | [!INCLUDEsssqlv14-md] Enterprise (Server+CAL License) |
* Also applies to [!INCLUDEsssqlv14-md] Express with Tools and [!INCLUDEsssqlv14-md] Express with Advanced Services.
** Changing the edition of a [!INCLUDEsssqlv14-md] failover cluster is limited. The following scenarios are not supported for [!INCLUDEsssqlv14-md] failover clusters:
-
[!INCLUDEsssqlv14-md] Enterprise to [!INCLUDEsssqlv14-md] Developer, Standard, or Evaluation.
-
[!INCLUDEsssqlv14-md] Developer to [!INCLUDEsssqlv14-md] Standard or Evaluation.
-
[!INCLUDEsssqlv14-md] Standard to [!INCLUDEsssqlv14-md] Evaluation.
-
[!INCLUDEsssqlv14-md] Evaluation to [!INCLUDEsssqlv14-md] Standard.
Editions and Supported Features for SQL Server 2017
Hardware and Software Requirements for Installing SQL Server