---
title: "Supported Version and Edition Upgrades (SQL Server 2016)"
description: The supported version and edition upgrades for SQL Server 2016.
ms.custom: ""
ms.date: "06/27/2016"
ms.prod: sql
ms.reviewer: ""
ms.technology: install
ms.topic: conceptual
helpviewer_keywords:
- "components [SQL Server], adding to existing installations"
- "versions [SQL Server], upgrading"
- "upgrading SQL Server, upgrades supported"
- "cross-language support"
ms.assetid: 702359c4-6ca9-42a8-860c-a95a802898a1
author: MashaMSFT
ms.author: mathoma
monikerRange: ">=sql-server-2016||=sqlallproducts-allversions"
---
# Supported version & edition upgrades (SQL Server 2016)
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-winonly](../../includes/appliesto-ss-xxxx-xxxx-xxx-md-winonly.md)]
You can upgrade from [!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)], [!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)], [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)], and [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)]. This article lists the supported upgrade paths from these [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] versions, and the supported edition upgrades for [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)].
## Pre upgrade Checklist
- Before upgrading from one edition of [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] to another, verify that the functionality you are currently using is supported in the edition to which you are moving.
- Before upgrading [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], enable Windows Authentication for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent and verify the default configuration: that the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent service account is a member of the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] sysadmin group.
- To upgrade to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)], you must be running a supported operating system. For more information, see [Hardware and Software Requirements for Installing SQL Server 2016](../../sql-server/install/hardware-and-software-requirements-for-installing-sql-server.md).
- Upgrade will be blocked if there is a pending restart.
- Upgrade will be blocked if the Windows Installer service is not running.
## Unsupported Scenarios
- Cross-version instances of [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] are not supported. Version numbers of the [!INCLUDE[ssDE](../../includes/ssde-md.md)], [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)], and [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)] components must be the same in an instance of [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)].
- [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] is only available for 64-bit platforms. Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to native 64-bit using [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Setup. However, you can back up or detach databases from a 32-bit instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], and then restore or attach them to a new instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. After you upgrade an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)], you can add features by using the [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Setup. For more information, see [Add Features to an Instance of SQL Server 2016 (Setup)](../../database-engine/install-windows/add-features-to-an-instance-of-sql-server-2016-setup.md).
- Failover Clusters are not supported in WOW mode.
- Upgrade from an Evaluation edition of a previous [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 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 [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)]
SQL Server 2016 supports upgrade from the following versions of SQL Server:
- [!INCLUDE[ssKatmai](../../includes/ssKatmai-md.md)] SP4 or later
- [!INCLUDE[ssKilimanjaro](../../includes/ssKilimanjaro-md.md)] SP3 or later
- [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 or later
- [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] or later
> [!NOTE]
> To upgrade databases on [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] see [Support for 2005](#SupportFor2005).
The table below lists the supported upgrade scenarios from earlier versions of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)].
|Upgrade from|Supported upgrade path|
|------------------|----------------------------|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Enterprise|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Developer|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Standard|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Small Business|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Web|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Workgroup|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] SP4 Express |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Datacenter|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Enterprise|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Developer|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Small Business|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Standard|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Web|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Workgroup|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssKilimanjaro](../../includes/sskilimanjaro-md.md)] SP3 Express |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Enterprise|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Developer|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Standard|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP1 Web|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Express |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express
|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Business Intelligence|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] SP2 Evaluation|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Evaluation
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Enterprise|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Developer|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Standard|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Web|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Express |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Business Intelligence|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
|
|[!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] Evaluation|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Evaluation
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer|
|[!INCLUDE[ssSQL15_md](../../includes/sssql15-md.md)] release candidate* |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise |
|[!INCLUDE[ssSQL15_md](../../includes/sssql15-md.md)] Developer |[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise |
\* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Technology Adoption Program (TAP).
### [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Support for [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)]
This section discusses [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] support for [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)]. In [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)], you will be able to do the following:
- Attach a [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] database (mdf/ldf files) to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] instance of database engine.
- Restore a [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] database to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] instance of database engine from a backup.
- Back up a [!INCLUDE[ssASversion2005](../../includes/ssasversion2005-md.md)] cube and restoring on [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)].
> [!NOTE]
> When a [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] database is upgraded to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)], the database compatibility level will be changed from 90 to 100.
> In [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)], valid values for the database compatibility level are 100, 110, 120, and 130. [ALTER DATABASE Compatibility Level (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md) discusses how the compatibility level change could affect [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] applications.
Any scenarios not specified in the list above are not supported, including but not limited to the following:
- Installing [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] and [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] on same computer (side by side).
- Using a [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] instance as a member of the replication topology that involves a [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] instance.
- Configuring database mirroring between [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] and [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] instances.
- Backing up the transaction log with log shipping between [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] and [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] instances.
- Configuring linked servers between [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] and [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] instances.
- Managing a [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] instance from a [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Management Studio.
- Attaching a [!INCLUDE[ssASversion2005](../../includes/ssasversion2005-md.md)] cube in [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Management Studio.
- Connecting to [!INCLUDE[ssISversion2005](../../includes/ssisversion2005-md.md)] from [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Management Studio.
- Managing a [!INCLUDE[ssISversion2005](../../includes/ssisversion2005-md.md)] service from [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Management Studio.
- Support for [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] third party custom Integration Services components, such as execute and upgrade.
## [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Edition Upgrade
The following table lists the supported edition upgrade scenarios in [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)].
For step-by-step instructions on how to perform an edition upgrade, see [Upgrade to a Different Edition of SQL Server 2016 (Setup)](../../database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup.md).
|Upgrade From|Upgrade To|
|------------------|----------------|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL and Core)**|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise |
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Evaluation Enterprise**|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL or Core License)
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer
[!INCLUDE[sssql15-md](../../includes/sssql15-md.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.|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard**|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL or Core License)|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer**|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL or Core License)
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL or Core License)
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express*|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL or Core License)
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard
[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Web|
Additionally you can also perform an edition upgrade between [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL license) and [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Core License):
|Edition Upgrade From|Edition Upgrade To|
|--------------------------|------------------------|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL License)**|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Core License)|
|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Core License)|[!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise (Server+CAL License)|
\* Also applies to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express with Tools and [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Express with Advanced Services.
** Changing the edition of a [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] failover cluster is limited. The following scenarios are not supported for [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] failover clusters:
- [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Enterprise to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer, Standard, or Evaluation.
- [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Developer to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard or Evaluation.
- [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Evaluation.
- [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Evaluation to [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] Standard.
## See Also
[Editions and Supported Features for SQL Server 2016](../../sql-server/editions-and-supported-features-for-sql-server-2016.md)
[Hardware and Software Requirements for Installing SQL Server 2016](../../sql-server/install/hardware-and-software-requirements-for-installing-sql-server.md)
[Upgrade to SQL Server 2016](../../database-engine/install-windows/upgrade-sql-server.md)