| title | Supported Version and Edition Upgrades - SQL Server 2019| Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 11/01/2019 | ||||
| ms.prod | sql | ||||
| ms.reviewer | |||||
| ms.technology | install | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 702359c4-6ca9-42a8-860c-a95a802898a1 | ||||
| author | MashaMSFT | ||||
| ms.author | mathoma | ||||
| monikerRange | >=sql-server-2017||=sqlallproducts-allversions |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
You can upgrade from [!INCLUDEssSQL11], [!INCLUDEssSQL14], [!INCLUDEsssql15-md], and [!INCLUDEsssql17-md]. This article lists the supported upgrade paths from these [!INCLUDEssNoVersion] versions, and the supported edition upgrades for [!INCLUDEsssqlv15-md].
-
Before upgrading from one edition of [!INCLUDEsssqlv15-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 [!INCLUDEsssqlv15-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 [!INCLUDEsssqlv15-md] are not supported. Version numbers of the [!INCLUDEssDE] components must be the same in an instance of [!INCLUDEsssqlv15-md].
-
[!INCLUDEsssqlv15-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 [!INCLUDEsssqlv15-md], you can add features by using the [!INCLUDEsssqlv15-md] Setup. For more information, see Add Features to an Instance of SQL Server (Setup).
Upgrades from Earlier Versions to [!INCLUDEsssqlv15-md]
[!INCLUDEsssqlv15-md] supports upgrade from the following versions of SQL Server:
- [!INCLUDEssSQL11] SP4 or later
- [!INCLUDEssSQL14] SP2 or later
- [!INCLUDEssSQL15] 13.0.1601.5 or later
- [!INCLUDEsssqlv15-md]
The table below lists the supported upgrade scenarios from earlier versions of [!INCLUDEssNoVersion] to [!INCLUDEsssqlv15-md].
| Upgrade from | Supported upgrade path |
|---|---|
| [!INCLUDEssSQL11] SP4 Enterprise | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL11] SP4 Developer | [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL11] SP4 Standard | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEssSQL11] SP4 Web | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
| [!INCLUDEssSQL11] SP4 Express | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Express |
| [!INCLUDEssSQL11] SP4 Business Intelligence | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL11] SP4 Evaluation | [!INCLUDEsssqlv15-md] Evaluation [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEssSQL14] SP2 Enterprise | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL14] SP2 Developer | [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL14] SP2 Standard | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEssSQL14] SP2 Web | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
| [!INCLUDEssSQL14] SP2 Express | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Express [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEssSQL14] SP2 Business Intelligence | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL14] SP2 Evaluation | [!INCLUDEsssqlv15-md] Evaluation [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEssSQL15] 13.0.1601.5 Enterprise | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL15] 13.0.1601.5 Developer | [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL15] 13.0.1601.5 Standard | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEssSQL15] 13.0.1601.5 Web | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
| [!INCLUDEssSQL15] 13.0.1601.5 Express | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Express [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEssSQL15] 13.0.1601.5 Business Intelligence | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL15] 13.0.1601.5 Evaluation | [!INCLUDEsssqlv15-md] Evaluation [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEsssqlv14] Enterprise | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEsssqlv14] Developer | [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEsssqlv14] Standard | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEsssqlv14] Web | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
| [!INCLUDEsssqlv14] Express | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Express [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEsssqlv14] Business Intelligence | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEsssqlv14] Evaluation | [!INCLUDEsssqlv15-md] Evaluation [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEsssqlv15-md] release candidate* | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEsssqlv15_md] Developer | [!INCLUDEsssqlv15-md] Enterprise |
* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Early Adopter Program.
For [!INCLUDE sskilimanjaro-md] and older, the following actions are not supported:
- Upgrade to [!INCLUDEsssqlv15-md].
- Attach database and log files.
- Restore database from backup.
- Installing [!INCLUDEsssqlv15-md] on same computer (side by side).
- Using a [!INCLUDE sskilimanjaro-md] or older instance as a member of the replication topology that involves a [!INCLUDEsssqlv15-md] instance.
- Configuring database mirroring between [!INCLUDEsssqlv15-md] and [!INCLUDE sskilimanjaro-md] or older instances.
- Backing up the transaction log with log shipping between [!INCLUDEsssqlv15-md] and [!INCLUDE sskilimanjaro-md] instances.
- Configuring linked servers between [!INCLUDEsssqlv15-md] and [!INCLUDEssVersion2005] instances.
- Managing a [!INCLUDE sskilimanjaro-md] or older instance from a [!INCLUDEsssqlv15-md] Management Studio or Azure Data Studio.
- Attaching a [!INCLUDE sskilimanjaro-md] or older cube in [!INCLUDEsssqlv15-md] Management Studio.
- Connecting to [!INCLUDE sskilimanjaro-md] or older SSIS service from [!INCLUDEsssqlv15-md] Management Studio or Azure Data Studio.
- Managing a [!INCLUDE sskilimanjaro-md] or older SSIS service from [!INCLUDEsssqlv15-md] Management Studio.
- Support for [!INCLUDE sskilimanjaro-md] or older third party custom Integration Services components, such as execute and upgrade.
[!INCLUDEsssqlv15-md] Edition Upgrade
The following table lists the supported edition upgrade scenarios in [!INCLUDEsssqlv15-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 |
|---|---|
| [!INCLUDEsssqlv15-md] Enterprise (Server+CAL and Core)** | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEsssqlv15-md] Evaluation Enterprise** | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-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. |
| [!INCLUDEsssqlv15-md] Standard** | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL or Core License) |
| [!INCLUDEsssqlv15-md] Developer** | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEsssqlv15-md] Web | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEsssqlv15-md] Express* | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL or Core License) [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
Additionally you can also perform an edition upgrade between [!INCLUDEsssqlv15-md] Enterprise (Server+CAL license) and [!INCLUDEsssqlv15-md] Enterprise (Core License):
| Edition Upgrade From | Edition Upgrade To |
|---|---|
| [!INCLUDEsssqlv15-md] Enterprise (Server+CAL License)** | [!INCLUDEsssqlv15-md] Enterprise (Core License) |
| [!INCLUDEsssqlv15-md] Enterprise (Core License) | [!INCLUDEsssqlv15-md] Enterprise (Server+CAL License) |
* Also applies to [!INCLUDEsssqlv15-md] Express with Tools and [!INCLUDEsssqlv15-md] Express with Advanced Services.
** Changing the edition of a clustered instance of [!INCLUDEsssqlv15-md] limited. The following scenarios are not supported for [!INCLUDEsssqlv15-md] failover clusters:
-
[!INCLUDEsssqlv15-md] Enterprise to [!INCLUDEsssqlv15-md] Developer, Standard, or Evaluation.
-
[!INCLUDEsssqlv15-md] Developer to [!INCLUDEsssqlv15-md] Standard or Evaluation.
-
[!INCLUDEsssqlv15-md] Standard to [!INCLUDEsssqlv15-md] Evaluation.
-
[!INCLUDEsssqlv15-md] Evaluation to [!INCLUDEsssqlv15-md] Standard.
[Editions and supported features of [!INCLUDEsssqlv15-md]](../../sql-server/editions-and-components-of-sql-server-version-15.md)
Hardware and software requirements for installing SQL Server