支持的版本和版本升级 (SQL Server 2016)Supported version & edition upgrades (SQL Server 2016)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only

你可以从 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2014 (12.x)SQL Server 2014 (12.x)进行升级。You can upgrade from SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), and SQL Server 2014 (12.x)SQL Server 2014 (12.x). 本文列出了支持的从这些 SQL ServerSQL Server 版本进行升级的途径以及支持的 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 版本升级。This article lists the supported upgrade paths from these SQL ServerSQL Server versions, and the supported edition upgrades for SQL Server 2016 (13.x)SQL Server 2016 (13.x).

升级前的清单Pre upgrade Checklist

  • 在从 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 的某个版本升级到另一个版本之前,请确认您当前所用的功能在要移到的版本中受支持。Before upgrading from one edition of SQL Server 2016 (13.x)SQL Server 2016 (13.x) to another, verify that the functionality you are currently using is supported in the edition to which you are moving.

  • 升级到 SQL ServerSQL Server之前,请先为 SQL ServerSQL Server Agent 启用 Windows 身份验证,并验证默认配置: SQL ServerSQL Server Agent 服务帐户是否是 SQL ServerSQL Server sysadmin 组的成员。Before upgrading SQL ServerSQL Server, enable Windows Authentication for SQL ServerSQL Server Agent and verify the default configuration: that the SQL ServerSQL Server Agent service account is a member of the SQL ServerSQL Server sysadmin group.

  • 若要升级到 SQL Server 2016 (13.x)SQL Server 2016 (13.x),您运行的必须是受支持的操作系统。To upgrade to SQL Server 2016 (13.x)SQL Server 2016 (13.x), you must be running a supported operating system. 有关详细信息,请参阅 安装 SQL Server 2016 的硬件和软件要求For more information, see Hardware and Software Requirements for Installing SQL Server 2016.

  • 如果有挂起的重新启动操作,则会阻止升级。Upgrade will be blocked if there is a pending restart.

  • 如果未运行 Windows Installer 服务,则会阻止升级。Upgrade will be blocked if the Windows Installer service is not running.

不受支持的方案Unsupported Scenarios

  • 不支持 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 的跨版本实例。Cross-version instances of SQL Server 2016 (13.x)SQL Server 2016 (13.x) are not supported. 数据库引擎Database EngineAnalysis ServicesAnalysis ServicesReporting ServicesReporting Services 组件的版本号在 SQL Server 2016 (13.x)SQL Server 2016 (13.x)实例中必须相同。Version numbers of the 数据库引擎Database Engine, Analysis ServicesAnalysis Services, and Reporting ServicesReporting Services components must be the same in an instance of SQL Server 2016 (13.x)SQL Server 2016 (13.x).

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) 仅适用于 64 位平台。is only available for 64-bit platforms. 不支持跨平台升级。Cross-platform upgrade is not supported. 不能使用 SQL ServerSQL Server 安装程序将 SQL ServerSQL Server 的 32 位实例升级到本机 64 位。You cannot upgrade a 32-bit instance of SQL ServerSQL Server to native 64-bit using SQL ServerSQL Server Setup. 但是,如果数据库未在复制过程中发布,则可以从 SQL ServerSQL Server的 32 位实例中备份或分离数据库,然后再将它们还原或附加到 SQL ServerSQL Server 的新实例(64 位)。However, you can back up or detach databases from a 32-bit instance of SQL ServerSQL Server, and then restore or attach them to a new instance of SQL ServerSQL Server (64-bit) if the databases are not published in replication. 必须在 master、msdb 和 model 系统数据库中重新创建任何登录名和其他用户对象。You must re-create any logins and other user objects in master, msdb, and model system databases.

  • 不能在升级现有的 SQL ServerSQL Server实例的过程中添加新功能。You cannot add new features during the upgrade of your existing instance of SQL ServerSQL Server. SQL ServerSQL Server 实例升级到 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 之后,您可以使用 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 安装程序添加功能。After you upgrade an instance of SQL ServerSQL Server to SQL Server 2016 (13.x)SQL Server 2016 (13.x), you can add features by using the SQL Server 2016 (13.x)SQL Server 2016 (13.x) Setup. 有关详细信息,请参阅向 SQL Server 2016 的实例添加功能(安装程序)For more information, see Add Features to an Instance of SQL Server 2016 (Setup).

  • 在 WOW 模式下不支持故障转移群集。Failover Clusters are not supported in WOW mode.

  • 不支持从以前的 SQL ServerSQL Server 版本的 Evaluation 版升级。Upgrade from an Evaluation edition of a previous SQL ServerSQL Server version is not supported.

  • 从 RC1 或以前版本的 SQL Server 2016 升级到 RC3 或更高版本时,必须在升级前卸载 PolyBase 并在升级后重新安装。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.

从早期版本升级到 SQL Server 2016 (13.x)SQL Server 2016 (13.x)Upgrades from Earlier Versions to SQL Server 2016 (13.x)SQL Server 2016 (13.x)

SQL Server 2016 支持从下列 SQL Server 版本升级:SQL Server 2016 supports upgrade from the following versions of SQL Server:

  • SQL Server 2008SQL Server 2008 SP4 或更高版本SP4 or later
  • SQL Server 2008 R2SQL Server 2008 R2 SP3 或更高版本SP3 or later
  • SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 或更高版本SP2 or later
  • SQL Server 2014 (12.x)SQL Server 2014 (12.x) 或更高版本or later

备注

若要在 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 上升级数据库,请参阅 2005 版本支持To upgrade databases on SQL Server 2005 (9.x)SQL Server 2005 (9.x) see Support for 2005.

下表列出了从 SQL ServerSQL Server 的早期版本升级到 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 的支持方案。The table below lists the supported upgrade scenarios from earlier versions of SQL ServerSQL Server to SQL Server 2016 (13.x)SQL Server 2016 (13.x).

升级前的版本Upgrade from 支持的升级途径Supported upgrade path
SQL Server 2008SQL Server 2008 SP4 EnterpriseSP4 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008SQL Server 2008 SP4 DeveloperSP4 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2008SQL Server 2008 SP4 StandardSP4 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 Small BusinessSP4 Small Business SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 WebSP4 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2008SQL Server 2008 SP4 WorkgroupSP4 Workgroup SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 ExpressSP4 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress
SQL Server 2008 R2SQL Server 2008 R2 SP3 DatacenterSP3 Datacenter SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008 R2SQL Server 2008 R2 SP3 EnterpriseSP3 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008 R2SQL Server 2008 R2 SP3 DeveloperSP3 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2008 R2SQL Server 2008 R2 SP3 Small BusinessSP3 Small Business SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 StandardSP3 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 WebSP3 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2008 R2SQL Server 2008 R2 SP3 WorkgroupSP3 Workgroup SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 ExpressSP3 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 EnterpriseSP2 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 DeveloperSP2 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 StandardSP2 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 WebSP1 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 ExpressSP2 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 商业智能SP2 Business Intelligence SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 EvaluationSP2 Evaluation SQL Server 2016 (13.x)SQL Server 2016 (13.x) EvaluationEvaluation

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2014 (12.x)SQL Server 2014 (12.x) EnterpriseEnterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) DeveloperDeveloper SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) StandardStandard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2014 (12.x)SQL Server 2014 (12.x) WebWeb SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2014 (12.x)SQL Server 2014 (12.x) ExpressExpress SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2014 (12.x)SQL Server 2014 (12.x) Business IntelligenceBusiness Intelligence SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) EvaluationEvaluation SQL Server 2016 (13.x)SQL Server 2016 (13.x) EvaluationEvaluation

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 候选发布*release candidate* SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

* 从候选发布升级的 Microsof 支持专门针对参与了技术采用计划 (TAP) 的客户。* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Technology Adoption Program (TAP).

SQL Server 2016 (13.x)SQL Server 2016 (13.x) SQL Server 2005 (9.x)SQL Server 2005 (9.x) 支持SQL Server 2016 (13.x)SQL Server 2016 (13.x) Support for SQL Server 2005 (9.x)SQL Server 2005 (9.x)

此节讨论针对 SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2005 (9.x)SQL Server 2005 (9.x)支持。This section discusses SQL Server 2016 (13.x)SQL Server 2016 (13.x) support for SQL Server 2005 (9.x)SQL Server 2005 (9.x). SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中,您能够执行以下操作:In SQL Server 2016 (13.x)SQL Server 2016 (13.x), you will be able to do the following:

  • SQL Server 2005 (9.x)SQL Server 2005 (9.x) 数据库(mdf/ldf 文件)附加到数据库引擎的 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 实例。Attach a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database (mdf/ldf files) to SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance of database engine.

  • 从备份将 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 数据库还原为数据库引擎的 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 实例。Restore a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database to SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance of database engine from a backup.

  • 备份 SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) 多维数据集并在 SQL Server 2016 (13.x)SQL Server 2016 (13.x)上还原。Back up a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube and restoring on SQL Server 2016 (13.x)SQL Server 2016 (13.x).

备注

SQL Server 2005 (9.x)SQL Server 2005 (9.x) 数据库升级到 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 时,该数据库兼容级别将从 90 更改为 100。When a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database is upgraded to SQL Server 2016 (13.x)SQL Server 2016 (13.x), the database compatibility level will be changed from 90 to 100. SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中,数据库兼容性级别的有效值为 100、110、120 和 130。In SQL Server 2016 (13.x)SQL Server 2016 (13.x), valid values for the database compatibility level are 100, 110, 120, and 130. ALTER DATABASE 兼容级别 (Transact-SQL) 讨论兼容级别更改可能会影响 SQL ServerSQL Server 应用程序的方式。ALTER DATABASE Compatibility Level (Transact-SQL) discusses how the compatibility level change could affect SQL ServerSQL Server applications.

不支持以上列表中未指定的任何方案,包括但不限于以下情况:Any scenarios not specified in the list above are not supported, including but not limited to the following:

  • 在相同计算机上安装 SQL Server 2005 (9.x)SQL Server 2005 (9.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x)(并行)。Installing SQL Server 2005 (9.x)SQL Server 2005 (9.x) and SQL Server 2016 (13.x)SQL Server 2016 (13.x) on same computer (side by side).

  • 使用 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 实例作为涉及 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 实例的复制拓扑的成员。Using a SQL Server 2005 (9.x)SQL Server 2005 (9.x) instance as a member of the replication topology that involves a SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2005 (9.x)SQL Server 2005 (9.x) 实例之间配置数据库镜像。Configuring database mirroring between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • 使用日志传送在 SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2005 (9.x)SQL Server 2005 (9.x) 实例之间备份事务日志。Backing up the transaction log with log shipping between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2005 (9.x)SQL Server 2005 (9.x) 实例之间配置链接服务器。Configuring linked servers between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • SQL Server 2005 (9.x)SQL Server 2005 (9.x) Management Studio 管理 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 实例。Managing a SQL Server 2005 (9.x)SQL Server 2005 (9.x) instance from a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) Management Studio 中附加 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 多维数据集。Attaching a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube in SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) Management Studio 连接到 SQL Server 2016 (13.x)SQL Server 2016 (13.x)Connecting to SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) from SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) Management Studio 管理 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 服务。Managing a SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) service from SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • 支持 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 第三方自定义 Integration Services 组件,如执行和升级。Support for SQL Server 2005 (9.x)SQL Server 2005 (9.x) third party custom Integration Services components, such as execute and upgrade.

SQL Server 2016 (13.x)SQL Server 2016 (13.x) 版本升级Edition Upgrade

下表列出了 SQL Server 2016 (13.x)SQL Server 2016 (13.x)中支持的版本升级方案。The following table lists the supported edition upgrade scenarios in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

有关如何执行版本升级的分步说明,请参阅升级到 SQL Server 2016 的不同版本(安装程序)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
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 和内核)**Enterprise (Server+CAL and Core)** SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation Enterprise**Evaluation Enterprise** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

对于独立安装,支持从 Evaluation(免费版本)升级到任何付费版本;但对于群集安装,则不支持此升级。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. 此限制不适用于安装在参与可用性组的 Windows 故障转移群集上的独立实例。This limitation does not apply to stand-alone instances installed on a Windows Failover Cluster participating in an availability group.
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard**Standard** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)Enterprise (Server+CAL or Core License)
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer**Developer** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express*Express* SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

此外,您还可以执行 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 或内核许可证)和 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(内核许可证)之间的版本升级:Additionally you can also perform an edition upgrade between SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (Server+CAL license) and SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (Core License):

版本升级自Edition Upgrade From 版本升级到Edition Upgrade To
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 许可证)**Enterprise (Server+CAL License)** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(内核许可证)Enterprise (Core License)
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(内核许可证)Enterprise (Core License) SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(服务器+CAL 许可证)Enterprise (Server+CAL License)

* 同样适用于 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Tools 和 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Advanced Services。* Also applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Tools and SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Advanced Services.

** 对 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 故障转移群集版本的更改受到限制。** Changing the edition of a SQL Server 2016 (13.x)SQL Server 2016 (13.x) failover cluster is limited. SQL Server 2016 (13.x)SQL Server 2016 (13.x) 故障转移群集不支持以下方案:The following scenarios are not supported for SQL Server 2016 (13.x)SQL Server 2016 (13.x) failover clusters:

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) 从 Enterprise 更改为 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer、Standard 或 Evaluation。Enterprise to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer, Standard, or Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) 从 Developer 更改为 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard 或 Evaluation。Developer to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard or Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard 更改为 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation。SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation 更改为 SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard。SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard.

另请参阅See Also

SQL Server 2016 的各版本和支持的功能 Editions and Supported Features for SQL Server 2016
安装 SQL Server 2016 的硬件和软件要求 Hardware and Software Requirements for Installing SQL Server 2016
升级到 SQL Server 2016Upgrade to SQL Server 2016