支援的版本與版本升級Supported Version and Edition Upgrades

您可以從 SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012升級。You can upgrade from SQL Server 2008SQL Server 2008, and SQL Server 2008 R2SQL Server 2008 R2, and SQL Server 2012SQL Server 2012. 本主題列出這些 [SQL Server]SQL Server 版本的支援升級路徑,以及可以升級至 SQL Server 2014SQL Server 2014的支援版本。This topic lists the supported upgrade paths from these [SQL Server]SQL Server versions, and the supported edition upgrades for SQL Server 2014SQL Server 2014.

升級前檢查清單Pre upgrade Checklist

  • SQL Server 2014SQL Server 2014 的一個版本升級到另一個版本之前,請確認您目前使用的功能在您目標版本中受到支援。Before upgrading from one edition of SQL Server 2014SQL Server 2014 to another, verify that the functionality you are currently using is supported in the edition to which you are moving.

  • 在升級 [SQL Server]SQL Server之前,請對 [SQL Server]SQL Server Agent 啟用 Windows 驗證,並確認預設組態: [SQL Server]SQL Server Agent 服務帳戶是 [SQL Server]SQL Server 系統管理員 (sysadmin) 群組的成員。Before upgrading [SQL Server]SQL Server, enable Windows Authentication for [SQL Server]SQL Server Agent and verify the default configuration: that the [SQL Server]SQL Server Agent service account is a member of the [SQL Server]SQL Server sysadmin group.

  • 若要升級到 SQL Server 2014SQL Server 2014,您必須執行支援的作業系統。To upgrade to SQL Server 2014SQL Server 2014, you must be running a supported operating system. 如需詳細資訊,請參閱< Hardware and Software Requirements for Installing SQL Server 2014>。For more information, see Hardware and Software Requirements for Installing SQL Server 2014.

  • 當重新啟動暫止時將會封鎖升級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 2014SQL Server 2014 的跨版本執行個體。Cross-version instances of SQL Server 2014SQL Server 2014 are not supported. Database EngineDatabase Engine執行個體內, Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesSQL Server 2014SQL Server 2014元件的版本號碼都必須相同。Version numbers of the Database EngineDatabase Engine, Analysis ServicesAnalysis Services, and Reporting ServicesReporting Services components must be the same in an instance of SQL Server 2014SQL Server 2014.

  • 不支援跨平台升級。Cross-platform upgrade is not supported. 您無法使用 [SQL Server]SQL Server 安裝程式,將 32 位元的 [SQL Server]SQL Server 執行個體升級到原生 64 位元。You cannot upgrade a 32-bit instance of [SQL Server]SQL Server to native 64-bit using [SQL Server]SQL Server Setup. 不過,您還是可以備份或卸離 [SQL Server]SQL Server之 32 位元執行個體的資料庫,而且如果複寫時未發行這些資料庫,也可以將它們還原或附加至 [SQL Server]SQL Server (64 位元) 的新執行個體。However, you can back up or detach databases from a 32-bit instance of [SQL Server]SQL Server, and then restore or attach them to a new instance of [SQL Server]SQL 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 Server]SQL Server執行個體期間加入新功能。You cannot add new features during the upgrade of your existing instance of [SQL Server]SQL Server. [SQL Server]SQL Server 的執行個體升級至 SQL Server 2014SQL Server 2014 之後,可使用 SQL Server 2014SQL Server 2014 安裝程式加入功能。After you upgrade an instance of [SQL Server]SQL Server to SQL Server 2014SQL Server 2014, you can add features by using the SQL Server 2014SQL Server 2014 Setup. 如需詳細資訊,請參閱 < 將功能加入至執行個體 SQL Server 2014 的(安裝)For more information, see Add Features to an Instance of SQL Server 2014 (Setup).

  • 在 WOW 模式下不支援容錯移轉叢集。Failover Clusters are not supported in WOW mode.

  • 不支援從舊版 [SQL Server]SQL Server 的 Evaluation Edition 升級。Upgrade from an Evaluation edition of a previous [SQL Server]SQL Server version is not supported.

從舊版升級至 SQL Server 2014SQL Server 2014Upgrades from Earlier Versions to SQL Server 2014SQL Server 2014

注意

下一節< SQL Server 2005SQL Server 2005SQL Server 2014SQL Server 2014 的支援>會更詳細地描述 SQL Server 2005SQL Server 2005的支援。Support for SQL Server 2005SQL Server 2005 is described in more detail in the next section, 'SQL Server 2014SQL Server 2014 support for SQL Server 2005SQL Server 2005'.

  • 在 64 位元伺服器的 32 位元子系統 (WOW64) 上,可以將 [SQL Server]SQL Server 32 位元版本升級至 SQL Server 2014SQL Server 2014[SQL Server]SQL Server 32-bit editions can be upgraded to SQL Server 2014SQL Server 2014 on the 32-bit subsystem (WOW64) of a 64-bit server.

  • [SQL Server]SQL Server 64 位元版本只能升級至 SQL Server 2014SQL Server 2014 64 位元伺服器。64-bit versions can be upgraded to SQL Server 2014SQL Server 2014 64-bit server only.

注意

當您升級至SQL Server 2014SQL Server 2014從舊版的[SQL Server]SQL ServerEnterprise edition 中,選擇 Enterprise Edition:核心為基礎的授權和 Enterprise Edition。When you upgrade to SQL Server 2014SQL Server 2014 from a prior version of [SQL Server]SQL Server Enterprise edition, choose between Enterprise Edition: Core-based Licensing and Enterprise Edition. 這些 Enterprise edition 只有在授權模式及支援的核心數目上限方面有差異。These Enterprise editions differ only with respect to the licensing modes and the maximum number of cores supported. 如需詳細資訊,請參閱 Compute Capacity Limits by Edition of SQL ServerFor more information, see Compute Capacity Limits by Edition of SQL Server.

SQL Server 2014SQL Server 2014 支援從下列版本的 [SQL Server]SQL Server 進行升級:supports upgrade from the following versions of [SQL Server]SQL Server:

  • SQL Server 2005SQL Server 2005 SP4 或更新版本SP4 or later

  • SQL Server 2008SQL Server 2008 SP3 或更新版本SP3 or later

  • SQL Server 2008 R2SQL Server 2008 R2 SP2 或更新版本SP2 or later

  • SQL Server 2012SQL Server 2012 SP1 或更新版本SP1 or later

下表列出從舊版 [SQL Server]SQL Server 升級至 SQL Server 2014SQL Server 2014 的支援案例。The table below lists the supported upgrade scenarios from earlier versions of [SQL Server]SQL Server to SQL Server 2014SQL Server 2014.

升級來源Upgrade from 支援的升級路徑Supported upgrade path
SQL Server 2005SQL Server 2005 SP4 EnterpriseSP4 Enterprise SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2005SQL Server 2005 SP4 DeveloperSP4 Developer SQL Server 2014SQL Server 2014 DeveloperDeveloper
SQL Server 2005SQL Server 2005 SP4 StandardSP4 Standard SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2005SQL Server 2005 SP4 WorkgroupSP4 Workgroup SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2005SQL Server 2005 SP4 ExpressSP4 Express,

SQL Server 2005SQL Server 2005 SP4 Express with Tools,以及SP4 Express with Tools, and

SQL Server 2005SQL Server 2005 SP4 Express with Advanced ServicesSP4 Express with Advanced Services
SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb

SQL Server 2014SQL Server 2014 ExpressExpress
SQL Server 2008SQL Server 2008 SP3 EnterpriseSP3 Enterprise SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2008SQL Server 2008 SP3 DeveloperSP3 Developer SQL Server 2014SQL Server 2014 DeveloperDeveloper
SQL Server 2008SQL Server 2008 SP3 StandardSP3 Standard SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008SQL Server 2008 SP3 Small BusinessSP3 Small Business SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008SQL Server 2008 SP3 WebSP3 Web SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb
SQL Server 2008SQL Server 2008 SP3 WorkgroupSP3 Workgroup SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008SQL Server 2008 SP3 ExpressSP3 Express,

SQL Server 2008SQL Server 2008 SP3 Express with Tools,以及SP3 Express with Tools, and

SQL Server 2008SQL Server 2008 SP3 Express with Advanced ServicesSP3 Express with Advanced Services
SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb

SQL Server 2014SQL Server 2014 ExpressExpress
SQL Server 2008 R2SQL Server 2008 R2 SP2 DatacenterSP2 Datacenter SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2008 R2SQL Server 2008 R2 SP2 EnterpriseSP2 Enterprise SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2008 R2SQL Server 2008 R2 SP2 DeveloperSP2 Developer SQL Server 2014SQL Server 2014 DeveloperDeveloper
SQL Server 2008 R2SQL Server 2008 R2 SP2 Small BusinessSP2 Small Business SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP2 StandardSP2 Standard SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP2 WebSP2 Web SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb
SQL Server 2008 R2SQL Server 2008 R2 SP2 WorkgroupSP2 Workgroup SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP2 ExpressSP2 Express,

SQL Server 2008 R2SQL Server 2008 R2 SP2 Express with Tools,以及SP2 Express with Tools, and

SQL Server 2008 R2SQL Server 2008 R2 SP2 Express with Advanced ServicesSP2 Express with Advanced Services
SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb

SQL Server 2014SQL Server 2014 ExpressExpress
SQL Server 2012SQL Server 2012 SP1 EnterpriseSP1 Enterprise SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2012SQL Server 2012 SP1 DeveloperSP1 Developer SQL Server 2014SQL Server 2014 DeveloperDeveloper
SQL Server 2012SQL Server 2012 SP1 StandardSP1 Standard SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2012SQL Server 2012 SP1 WebSP1 Web SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb
SQL Server 2012SQL Server 2012 SP1 ExpressSP1 Express,

SQL Server 2012SQL Server 2012 SP1 Express with Tools,以及SP1 Express with Tools, and

SQL Server 2012SQL Server 2012 SP1 Express Management Studio,以及SP1 Express Management Studio, and

SQL Server 2012SQL Server 2012 SP1 Express with Advanced ServicesSP1 Express with Advanced Services
SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb

SQL Server 2014SQL Server 2014 ExpressExpress
SQL Server 2012SQL Server 2012 SP1 Business IntelligenceSP1 Business Intelligence SQL Server 2014SQL Server 2014 EnterpriseEnterprise

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2005SQL Server 2005 SQL Server 2014SQL Server 2014 支援Support for SQL Server 2005SQL Server 2005

本節將討論 SQL Server 2014SQL Server 2014SQL Server 2005SQL Server 2005 的支援。This section discusses SQL Server 2014SQL Server 2014 support for SQL Server 2005SQL Server 2005. SQL Server 2014SQL Server 2014中,您將能夠進行下列作業:In SQL Server 2014SQL Server 2014, you will be able to do the following:

  • 使用安裝精靈或是從命令提示字元執行 SQL Server 2005SQL Server 2005 安裝程式,將 SQL Server 2014SQL Server 2014 的資料庫引擎執行個體升級到 SQL Server 2014SQL Server 2014Upgrade a SQL Server 2005SQL Server 2005 instance of database engine to SQL Server 2014SQL Server 2014 by running SQL Server 2014SQL Server 2014 setup using the installation wizard or from the command prompt.

  • SQL Server 2005SQL Server 2005 資料庫 (mdf/ldf 檔案) 附加到 SQL Server 2014SQL Server 2014 的 Database Engine 執行個體。Attach a SQL Server 2005SQL Server 2005 database (mdf/ldf files) to SQL Server 2014SQL Server 2014 instance of database engine.

  • 從備份將 SQL Server 2005SQL Server 2005 資料庫還原到 SQL Server 2014SQL Server 2014 的 Database Engine 執行個體。Restore a SQL Server 2005SQL Server 2005 database to SQL Server 2014SQL Server 2014 instance of database engine from a backup.

  • SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) 封裝升級到 SQL Server 2014SQL Server 2014Upgrade a SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) package to SQL Server 2014SQL Server 2014. 執行封裝並包含自動就地升級。Execute packages with automatic-in-place upgrade.

  • 藉由執行 SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) 安裝程式將 SQL Server 2014SQL Server 2014 升級到 SQL Server 2014SQL Server 2014Upgrade a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) to SQL Server 2014SQL Server 2014 by running SQL Server 2014SQL Server 2014 setup.

  • 備份 SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) Cube 並在 SQL Server 2014SQL Server 2014上還原。Back up a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube and restoring on SQL Server 2014SQL Server 2014.

  • 藉由執行 SQL Server 2005 Reporting Services (SSRS)SQL Server 2005 Reporting Services (SSRS) 安裝程式將 SQL Server 2014SQL Server 2014 升級到 SQL Server 2014SQL Server 2014Upgrade SQL Server 2005 Reporting Services (SSRS)SQL Server 2005 Reporting Services (SSRS) to SQL Server 2014SQL Server 2014 by running SQL Server 2014SQL Server 2014 setup.

  • 使用 SQL Server 2005SQL Server 20052014 連接到 SQL Server ProfilerSQL Server ProfilerConnect to SQL Server 2005SQL Server 2005by using SQL Server ProfilerSQL Server Profiler 2014.

SQL Server 2005SQL Server 2005 資料庫升級到 SQL Server 2014SQL Server 2014 時,資料庫的相容性層級將會從 90 變更為 100。When a SQL Server 2005SQL Server 2005 database is upgraded to SQL Server 2014SQL Server 2014, the database compatibility level will be changed from 90 to 100. (在SQL Server 2014SQL Server 2014,資料庫相容性層級的有效值為 100、 110 和 120。)ALTER DATABASE 相容性層級 (Transact-SQL) 中有討論相容性層級變更如何影響 [SQL Server]SQL Server 應用程式的情形。(In SQL Server 2014SQL Server 2014, valid values for the database compatibility level are 100, 110 and 120.) ALTER DATABASE Compatibility Level (Transact-SQL) discusses how the compatibility level change could affect [SQL Server]SQL Server applications.

未在上面清單中指定的任何情況都不受支援,包含但不限於以下項目:Any scenarios not specified in the list above are not supported, including but not limited to the following:

  • 在相同電腦上安裝 SQL Server 2005SQL Server 2005SQL Server 2014SQL Server 2014 (並存安裝)。Installing SQL Server 2005SQL Server 2005 and SQL Server 2014SQL Server 2014 on same computer (side by side).

  • 使用 SQL Server 2005SQL Server 2005 執行個體當做與 SQL Server 2014SQL Server 2014 執行個體有關之複寫拓撲的成員。Using a SQL Server 2005SQL Server 2005 instance as a member of the replication topology that involves a SQL Server 2014SQL Server 2014 instance.

  • SQL Server 2014SQL Server 2014SQL Server 2005SQL Server 2005 執行個體之間設定資料庫鏡像。Configuring database mirroring between SQL Server 2014SQL Server 2014 and SQL Server 2005SQL Server 2005 instances.

  • SQL Server 2014SQL Server 2014SQL Server 2005SQL Server 2005 執行個體之間使用記錄傳送備份交易記錄。Backing up the transaction log with log shipping between SQL Server 2014SQL Server 2014 and SQL Server 2005SQL Server 2005 instances.

  • SQL Server 2014SQL Server 2014SQL Server 2005SQL Server 2005 執行個體之間設定連結的伺服器。Configuring linked servers between SQL Server 2014SQL Server 2014 and SQL Server 2005SQL Server 2005 instances.

  • SQL Server 2005SQL Server 2005 Management Studio 管理 SQL Server 2014SQL Server 2014 執行個體。Managing a SQL Server 2005SQL Server 2005 instance from a SQL Server 2014SQL Server 2014 Management Studio.

  • SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) Management Studio 中附加 SQL Server 2014SQL Server 2014 Cube。Attaching a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube in SQL Server 2014SQL Server 2014 Management Studio.

  • SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) Management Studio 連接到 SQL Server 2014SQL Server 2014Connecting to SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) from SQL Server 2014SQL Server 2014 Management Studio.

  • SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) Management Studio 管理 SQL Server 2014SQL Server 2014 服務。Managing a SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) service from SQL Server 2014SQL Server 2014 Management Studio.

  • SQL Server 2005SQL Server 2005 協力廠商自訂 Integration Services 元件的支援,例如執行和升級。Support for SQL Server 2005SQL Server 2005 third party custom Integration Services components, such as execute and upgrade.

SQL Server 2014SQL Server 2014 版本升級Edition Upgrade

下表列出 SQL Server 2014SQL Server 2014中支援的版本升級案例。The following table lists the supported edition upgrade scenarios in SQL Server 2014SQL Server 2014.

如需如何執行版本升級的逐步指示,請參閱升級至不同版本的 SQL Server 2014(安裝)For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server 2014 (Setup).

升級來源Upgrade From 升級目標Upgrade To
SQL Server 2014SQL Server 2014 Enterprise (Server + CAL 和 Core) 2Enterprise (Server+CAL and Core) 2 SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence
SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)
SQL Server 2014SQL Server 2014 Evaluation Enterprise 2Evaluation Enterprise 2 SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 DeveloperDeveloper

SQL Server 2014SQL Server 2014 WebWeb

對於獨立安裝,支援從 Evaluation Enterprise (免費版本) 升級到任何付費版本,但對於叢集安裝則不支援。Upgrading from Evaluation Enterprise (a free edition) to any of the paid editions is supported for stand-alone installations, but is not supported for clustered installations.
SQL Server 2014SQL Server 2014 標準2Standard 2 SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)
SQL Server 2014SQL Server 2014 開發人員2Developer 2 SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 WebWeb

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2014SQL Server 2014 WebWeb SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 StandardStandard
SQL Server 2014SQL Server 2014 Express 1Express 1 SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 或 Core 授權)Enterprise (Server+CAL or Core License)

SQL Server 2014SQL Server 2014 Business IntelligenceBusiness Intelligence

SQL Server 2014SQL Server 2014 DeveloperDeveloper

SQL Server 2014SQL Server 2014 StandardStandard

SQL Server 2014SQL Server 2014 WebWeb

此外,您也可以在 SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 授權) 和 SQL Server 2014SQL Server 2014 Enterprise (Core 授權) 之間執行版本升級:Additionally you can also perform an edition upgrade between SQL Server 2014SQL Server 2014 Enterprise (Server+CAL license) and SQL Server 2014SQL Server 2014 Enterprise (Core License):

升級前版本Edition Upgrade From 升級後版本Edition Upgrade To
SQL Server 2014SQL Server 2014 Enterprise (Server + CAL 授權) 2Enterprise (Server+CAL License) 2 SQL Server 2014SQL Server 2014 Enterprise (Core 授權)Enterprise (Core License)
SQL Server 2014SQL Server 2014 Enterprise (Core 授權)Enterprise (Core License) SQL Server 2014SQL Server 2014 Enterprise (Server+CAL 授權)Enterprise (Server+CAL License)

1也適用於SQL Server 2014SQL Server 2014Express with Tools 和SQL Server 2014SQL Server 2014Express with Advanced Services。1 Also applies to SQL Server 2014SQL Server 2014 Express with Tools and SQL Server 2014SQL Server 2014 Express with Advanced Services.

2變更的版本SQL Server 2014SQL Server 2014容錯移轉叢集是有限。2 Changing the edition of a SQL Server 2014SQL Server 2014 failover cluster is limited. 下列狀況不支援 SQL Server 2014SQL Server 2014 容錯移轉叢集:The following scenarios are not supported for SQL Server 2014SQL Server 2014 failover clusters:

  • SQL Server 2014 Enterprise 至 SQL Server 2014 Developer、Standard 和 Enterprise Evaluation。SQL Server 2014 Enterprise to SQL Server 2014 Developer, Standard, or Enterprise Evaluation.

  • SQL Server 2014 Developer 至 SQL Server 2014 Standard 或 Enterprise Evaluation。SQL Server 2014 Developer to SQL Server 2014 Standard or Enterprise Evaluation.

  • SQL Server 2014 Standard 至 SQL Server 2014 Enterprise Evaluation。SQL Server 2014 Standard to SQL Server 2014 Enterprise Evaluation.

  • SQL Server 2014 Enterprise Evaluation 至 SQL Server 2014 Standard。SQL Server 2014 Enterprise Evaluation to SQL Server 2014 Standard.

另請參閱See Also

SQL Server 2014 各版本所支援的功能 Features Supported by the Editions of SQL Server 2014
硬體和 Software Requirements for Installing SQL Server 2014 Hardware and Software Requirements for Installing SQL Server 2014
升級到 SQL Server 2014 Upgrade to SQL Server 2014
使用 Upgrade Advisor 來準備升級Use Upgrade Advisor to Prepare for Upgrades