SQL Server 2014 的版本和元件Editions and Components of SQL Server 2014

安裝需求根據應用程式的需要而異。Installation requirements vary based on your application needs. 不同的 [SQL Server]SQL Server 版本可配合組織和個人的獨特效能、執行階段和價格需求。The different editions of [SQL Server]SQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals. 安裝的 [SQL Server]SQL Server 元件也將取決於您的特定需求。The [SQL Server]SQL Server components that you install also depend on your specific requirements. 下列章節幫助您了解如何在 [SQL Server]SQL Server的可用版本和元件之間做出最好的選擇。The following sections help you understand how to make the best choice among the editions and components available in [SQL Server]SQL Server.

SQL Server 2014SQL Server 2014 的主要版本Principal Editions of SQL Server 2014SQL Server 2014

下表描述 [SQL Server]SQL Server 的主要版本。The following table describes the principal editions of [SQL Server]SQL Server. 如需詳細資訊,請參閱支援的 SQL Server 2014 的版本功能For more information, see Features Supported by the Editions of SQL Server 2014

[SQL Server]SQL Server 版本edition 定義Definition
Enterprise (64 位元和 32 位元)Enterprise (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Enterprise Edition 這套頂級供應項目不但提供完整的高階資料中心功能,而且具備急速效能、不受限制的虛擬化以及端對端商業智慧 - 為關鍵任務工作負載提供最高的服務等級,並且讓使用者獲得資料洞察能力。The premium offering, SQL Server 2014SQL Server 2014 Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence - enabling high service levels for mission-critical workloads and end user access to data insights.
Business Intelligence (64 位元和 32 位元)Business Intelligence (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Business Intelligence Edition 提供了一套完整的平台,讓組織能夠建置並部署安全、可擴充且可管理的 BI 方案。Business Intelligence edition delivers comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. 此外,它提供了創新的功能,例如瀏覽器架構的資料探索和視覺效果、功能強大的資料結合功能,以及強化的整合管理。It offers exciting functionality such as browser based data exploration and visualization; powerful data mash-up capabilities, and enhanced integration management.
Standard (64 位元和 32 位元)Standard (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Standard Edition 針對部門和小型組織提供基本的資料管理與商業智慧資料庫來執行應用程式,並且支援內部部署和雲端的一般開發工具 - 以最少的 IT 資源提供最有效率的資料庫管理。Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud - enabling effective database management with minimal IT resources.

SQL Server 2014SQL Server 2014 的特殊版本Specialized Editions of SQL Server 2014SQL Server 2014

[SQL Server]SQL Server 的特殊版本是以商業工作負載為目標。Specialized editions of [SQL Server]SQL Server are targeted for business workloads. 下表描述 [SQL Server]SQL Server 的特殊版本。The following table describes the specialized editions of [SQL Server]SQL Server.

[SQL Server]SQL Server 版本edition 描述Description
Web (64 位元和 32 位元)Web (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Web Edition 對於 Web 主控者和 Web VAP 而言是一個整體擁有成本很低的選擇,可針對小型到大型規模的 Web 屬性提供可擴充、負擔輕鬆而且管理方便的功能。Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.

SQL Server 2014SQL Server 2014 的廣泛版本Breadth Editions of SQL Server 2014SQL Server 2014

[SQL Server]SQL Server 的廣泛版本是針對特定客戶案例所設計,將免費提供或以非常低廉的成本提供。Breadth editions of [SQL Server]SQL Server are engineered for specific customer scenarios and are offered FREE or at a very nominal cost. 下表描述 [SQL Server]SQL Server 的廣泛版本。The following table describes the breadth editions of [SQL Server]SQL Server.

[SQL Server]SQL Server 版本edition 描述Description
Developer (64 位元和 32 位元)Developer (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Developer Edition 可讓開發人員在 [SQL Server]SQL Server上建立任何類型的應用程式。Developer edition lets developers build any kind of application on top of [SQL Server]SQL Server. 其中包含 Enterprise Edition 的所有功能,但是只授權做為開發和測試系統使用,而不做為實際伺服器使用。It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. [SQL Server]SQL Server Developer 是供應用程式建立和測試人員使用的理想選擇。Developer is an ideal choice for people who build and test applications.
Express (64 位元和 32 位元) EditionExpress (64-bit and 32-bit) editions SQL Server 2014SQL Server 2014 Express Edition 是入門級免費伺服器,非常適合用來學習及建置桌上型電腦和小型伺服器資料驅動應用程式。Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. 這個版本是獨立軟體廠商、開發人員及建置用戶端應用程式之愛好者的最佳選擇。It is the best choice for independent software vendors, developers, and hobbyists building client applications. 如果您需要更進階的資料庫功能, [SQL Server]SQL Server Express 可以順利地升級為其他更高階的 [SQL Server]SQL Server版本。If you need more advanced database features, [SQL Server]SQL Server Express can be seamlessly upgraded to other higher end versions of [SQL Server]SQL Server. [SQL Server]SQL Server Express LocalDB 是輕量版 Express,其中包含所有程式設計功能但是以使用者模式執行,並配備快速的零設定安裝,而且所需必要條件很少。Express LocalDB, a lightweight version of Express that has all of its programmability features, yet runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.

搭配網際網路伺服器使用 [SQL Server]SQL ServerUsing [SQL Server]SQL Server with an Internet Server

在網際網路伺服器中,例如執行 Internet Information Services (IIS) 的伺服器,您通常會安裝 [SQL Server]SQL Server 用戶端工具。On an Internet server, such as a server that is running Internet Information Services (IIS), you will typically install the [SQL Server]SQL Server client tools. 用戶端工具包括連接到 [SQL Server]SQL Server執行個體的應用程式所使用的用戶端連接元件。Client tools include the client connectivity components used by an application connecting to an instance of [SQL Server]SQL Server.


雖然您可以在執行 IIS 的電腦上安裝 [SQL Server]SQL Server 的執行個體,但通常只有針對具有單一伺服器電腦的小型網站才會這麼做。Although you can install an instance of [SQL Server]SQL Server on a computer that is running IIS, this is typically done only for small Web sites that have a single server computer. 大部分網站會將它們的中介層 IIS 系統放在一部伺服器或伺服器叢集上,並將其資料庫放在另一部伺服器或伺服器聯盟上。Most Web sites have their middle-tier IIS systems on one server or a cluster of servers, and their databases on a separate server or federation of servers.

搭配用戶端/伺服器應用程式使用 [SQL Server]SQL ServerUsing [SQL Server]SQL Server with Client/Server Applications

您可以在執行用戶端/伺服器應用程式的電腦上只安裝 [SQL Server]SQL Server 用戶端元件,這些應用程式會直接連接到 [SQL Server]SQL Server的執行個體。You can install just the [SQL Server]SQL Server client components on a computer that is running client/server applications that connect directly to an instance of [SQL Server]SQL Server. 如果您要在資料庫伺服器上管理 [SQL Server]SQL Server 的執行個體,或您打算開發 [SQL Server]SQL Server 應用程式,則用戶端元件安裝也是一個不錯的選項。A client components installation is also a good option if you administer an instance of [SQL Server]SQL Server on a database server, or if you plan to develop [SQL Server]SQL Server applications.

用戶端工具選項會安裝下列 [SQL Server]SQL Server 功能:回溯相容性元件、 SQL Server Data ToolsSQL Server Data Tools、連接元件、管理工具、軟體開發套件和《 [SQL Server]SQL Server 線上叢書》元件。The client tools option installs the following [SQL Server]SQL Server features: backward compatibility components, SQL Server Data ToolsSQL Server Data Tools, connectivity components, management tools, software development kit, and [SQL Server]SQL Server Books Online components. 如需詳細資訊,請參閱 < 從安裝精靈安裝 SQL Server 2014(安裝)For more information, see Install SQL Server 2014 from the Installation Wizard (Setup).

[SQL Server]SQL Server 元件之間作決定Deciding Among [SQL Server]SQL Server Components

使用 [SQL Server]SQL Server 安裝精靈的 [特徵選取] 頁面來選取要併入 [SQL Server]SQL Server安裝的元件。Use the Feature Selection page of the [SQL Server]SQL Server Installation Wizard to select the components to include in an installation of [SQL Server]SQL Server. 依預設,不會選取樹狀結構中的任何功能。By default, none of the features in the tree are selected.

請使用下表中的資訊來判斷最符合您需求的功能集。Use the information in the following tables to determine the set of features that best fits your needs.

伺服器元件Server components 描述Description
SQL Server Database EngineSQL Server Database Engine SQL Server Database EngineSQL Server Database Engine 包含 Database EngineDatabase Engine、用來儲存、處理及保護資料安全的核心服務、複寫、全文檢索搜尋功能、用來管理關聯式和 XML 資料的工具,以及 Data Quality ServicesData Quality Services (DQS) 伺服器。includes the Database EngineDatabase Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, and the Data Quality ServicesData Quality Services (DQS) server.
Analysis ServicesAnalysis Services Analysis ServicesAnalysis Services 包括用來建立及管理線上分析處理 (OLAP) 和資料採礦應用程式的工具。includes the tools for creating and managing online analytical processing (OLAP) and data mining applications.
Reporting ServicesReporting Services Reporting ServicesReporting Services 包括伺服器和用戶端元件,可用來建立、管理和部署表格式、矩陣、圖形化和自由形式報表。includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting ServicesReporting Services 也是一個可延伸的平台,可讓您用來開發報表應用程式。is also an extensible platform that you can use to develop report applications.
Integration ServicesIntegration Services Integration ServicesIntegration Services 是一組圖形化工具和可程式化物件,用來移動、複製和轉換資料。is a set of graphical tools and programmable objects for moving, copying, and transforming data. 其中還包括 Data Quality ServicesData Quality ServicesIntegration ServicesIntegration Services(DQS) 元件。It also includes the Data Quality ServicesData Quality Services (DQS) component for Integration ServicesIntegration Services.
Master Data ServicesMaster Data Services Master Data ServicesMaster Data Services (MDS) 是用於主要資料管理的 [SQL Server]SQL Server 方案。(MDS) is the [SQL Server]SQL Server solution for master data management. MDS 可設定為管理任何網域 (產品、客戶、帳戶) 而且包括階層、更細微的安全性、交易、資料版本控制和商務規則,以及可用來管理資料的 新增-中適用於 ExcelAdd-in for ExcelMDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an 新增-中適用於 ExcelAdd-in for Excel that can be used to manage data.
管理工具Management tools 描述Description
Transact-SQLSQL Server Management Studio Transact-SQLSQL Server Management Studio 是一個整合式環境,可存取、設定、管理及開發 [SQL Server]SQL Server的元件。is an integrated environment to access, configure, manage, administer, and develop components of [SQL Server]SQL Server. Management StudioManagement Studio 可讓所有技能等級的開發人員和管理員使用 [SQL Server]SQL Serverlets developers and administrators of all skill levels use [SQL Server]SQL Server.
[SQL Server]SQL Server 組態管理員Configuration Manager [SQL Server]SQL Server 組態管理員對 [SQL Server]SQL Server 服務、伺服器通訊協定、用戶端通訊協定和用戶端別名提供基本組態管理。Configuration Manager provides basic configuration management for [SQL Server]SQL Server services, server protocols, client protocols, and client aliases.
SQL Server ProfilerSQL Server Profiler SQL Server ProfilerSQL Server Profiler 提供圖形化使用者介面來監視 Database EngineDatabase EngineAnalysis ServicesAnalysis Services的執行個體。provides a graphical user interface to monitor an instance of the Database EngineDatabase Engine or Analysis ServicesAnalysis Services.
Database EngineDatabase Engine Tuning AdvisorTuning Advisor Database EngineDatabase Engine Tuning Advisor 協助您建立一組最佳的索引、索引檢視表和分割區。Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
Data Quality ClientData Quality Client 提供相當簡單且高度直覺式的圖形使用者介面來連接 DQS 伺服器,以及執行資料清除作業。Provides a highly simple and intuitive graphical user interface to connect to the DQS server, and perform data cleansing operations. 此外還可讓您集中監控資料清除作業期間執行的各種活動。It also allows you to centrally monitor various activities performed during the data cleansing operation.
SQL Server Data ToolsSQL Server Data Tools SQL Server Data ToolsSQL Server Data Tools 提供 IDE,可用來為下列商業智慧元件建立方案: Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesIntegration ServicesIntegration Servicesprovides an IDE for building solutions for the Business Intelligence components: Analysis ServicesAnalysis Services, Reporting ServicesReporting Services, and Integration ServicesIntegration Services.

(先前稱為 Business Intelligence Development Studio)。(Formerly called Business Intelligence Development Studio).

SQL Server Data ToolsSQL Server Data Tools 也包含「資料庫專案」,為資料庫開發人員提供整合環境,以實現 Visual Studio 內任何 [SQL Server]SQL Server 平台 (內部和外部部署) 適用的所有資料庫設計工作。also includes "Database Projects", which provides an integrated environment for database developers to carry out all their database design work for any [SQL Server]SQL Server platform (both on and off premise) within Visual Studio. 資料庫開發人員可以使用 Visual Studio 中的增強伺服器總管,輕鬆建立或編輯資料庫物件和資料,或執行查詢。Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.
連接元件Connectivity Components 安裝用於用戶端和伺服器之間通訊的元件以及用於 DB-Library、ODBC 和 OLE DB 的網路程式庫。Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.
文件集Documentation 描述Description
[SQL Server]SQL Server 線上叢書Books Online [SQL Server]SQL Server的核心文件集。Core documentation for [SQL Server]SQL Server.

另請參閱See Also

規劃 SQL Server 安裝 Planning a SQL Server Installation
從安裝精靈安裝 SQL Server 2014(安裝程式)Install SQL Server 2014 from the Installation Wizard (Setup)