| title | Supported version and edition upgrades (SQL Server 2019) | ||||
|---|---|---|---|---|---|
| description | The supported version and edition upgrades for SQL Server 2019. | ||||
| ms.custom | |||||
| ms.date | 11/04/2019 | ||||
| ms.prod | sql | ||||
| ms.reviewer | |||||
| ms.technology | install | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 702359c4-6ca9-42a8-860c-a95a802898a1 | ||||
| author | cawrites | ||||
| ms.author | chadam | ||||
| monikerRange | >=sql-server-2017 |
[!INCLUDE SQL Server -Windows Only]
You can upgrade from [!INCLUDEssSQL11], [!INCLUDEssSQL14], [!INCLUDEsssql16-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.
- Verify supported hardware and software.
- 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] SP3 or later
- [!INCLUDEssSQL16] SP2 or later
- [!INCLUDEsssql17-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 |
| [!INCLUDEssSQL16] 13.0.1601.5 Enterprise | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL16] 13.0.1601.5 Developer | [!INCLUDEsssqlv15-md] Developer [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL16] 13.0.1601.5 Standard | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard |
| [!INCLUDEssSQL16] 13.0.1601.5 Web | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web |
| [!INCLUDEssSQL16] 13.0.1601.5 Express | [!INCLUDEsssqlv15-md] Enterprise [!INCLUDEsssqlv15-md] Standard [!INCLUDEsssqlv15-md] Web [!INCLUDEsssqlv15-md] Express [!INCLUDEsssqlv15-md] Developer |
| [!INCLUDEssSQL16] 13.0.1601.5 Business Intelligence | [!INCLUDEsssqlv15-md] Enterprise |
| [!INCLUDEssSQL16] 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.
You can migrate databases from older versions. For example, you can migrate databases from [!INCLUDE sskilimanjaro-md] to SQL Server 2019.
For information, see Azure Database Migration Guide.
The following tips and tools can help you plan and implement your migration.
-
Migration tools: Migration is supported through Data Migration Assistant (DMA).
-
Backup and restore: A backup taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2019.
-
Log shipping: Log shipping is supported if primary is running SQL Server 2008 SP3 or later, or SQL Server 2008 R2 SP2 or later, and secondary is running SQL Server 2019.
[!WARNING] If an automatic or manual failover happens and the SQL Server 2019 instance becomes primary, SQL Server 2008 or SQL Server 2008 R2 instance becomes secondary and cannot receive changes from primary.
-
Bulk load: Tables can be bulk copied from SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2019.
[!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. This limitation does not apply to stand-alone instances installed on a Windows Failover Cluster participating in an availability group. |
| [!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