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

根据应用程序的需要,安装要求会有所不同。Installation requirements vary based on your application needs. 不同版本的 SQL ServerSQL Server 能够满足单位和个人独特的性能、运行时以及价格要求。The different editions of SQL ServerSQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals. 安装哪些 SQL ServerSQL Server 组件还取决于您的具体需要。The SQL ServerSQL Server components that you install also depend on your specific requirements. 下面各节将帮助您了解如何在 SQL ServerSQL Server的不同版本和可用组件中做出最佳选择。The following sections help you understand how to make the best choice among the editions and components available in SQL ServerSQL Server.

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

下表介绍 SQL ServerSQL Server 的主要版本。The following table describes the principal editions of SQL ServerSQL Server. 有关详细信息,请参阅SQL Server 2014 各个版本支持的功能For more information, see Features Supported by the Editions of SQL Server 2014

SQL ServerSQL Server 版本edition 定义Definition
Enterprise(64 位和 32 位)Enterprise (64-bit and 32-bit) 作为高级版本,SQL Server 2014SQL Server 2014 Enterprise 版提供了全面的高端数据中心功能,性能极为快捷、虚拟化不受限制,还具有端到端的商业智能,可为关键任务工作负荷提供较高服务级别,支持最终用户访问深层数据。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 版提供了综合性平台,可支持组织构建和部署安全、可扩展且易于管理的 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 版提供了基本数据管理和商业智能数据库,使部门和小型组织能够顺利运行其应用程序并支持将常用开发工具用于内部部署和云部署,有助于以最少的 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 ServerSQL Server 面向不同的业务工作负荷。Specialized editions of SQL ServerSQL Server are targeted for business workloads. 下表介绍 SQL ServerSQL Server 的专业化版本。The following table describes the specialized editions of SQL ServerSQL Server.

SQL ServerSQL Server 版本edition DescriptionDescription
Web(64 位和 32 位)Web (64-bit and 32-bit) 对于为从小规模至大规模 Web 资产提供可伸缩性、经济性和可管理性功能的 Web 宿主和 Web VAP 来说,SQL Server 2014SQL Server 2014 Web 版本是一项总拥有成本较低的选择。SQL Server 2014SQL Server 2014 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 ServerSQL Server 延伸版是针对特定的用户应用而设计的,可免费获取或只需支付极少的费用。Breadth editions of SQL ServerSQL Server are engineered for specific customer scenarios and are offered FREE or at a very nominal cost. 下表介绍 SQL ServerSQL Server 的延伸版本。The following table describes the breadth editions of SQL ServerSQL Server.

SQL ServerSQL Server 版本edition DescriptionDescription
Developer(64 位和 32 位)Developer (64-bit and 32-bit) SQL Server 2014SQL Server 2014 Developer 版支持开发人员基于 SQL ServerSQL Server构建任意类型的应用程序。Developer edition lets developers build any kind of application on top of SQL ServerSQL Server. 它包括 Enterprise 版的所有功能,但有许可限制,只能用作开发和测试系统,而不能用作生产服务器。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 ServerSQL Server Developer 是构建和测试应用程序的人员的理想之选。Developer is an ideal choice for people who build and test applications.
Express 版(64 位和 32 位)Express (64-bit and 32-bit) editions SQL Server 2014SQL Server 2014 Express 是入门级的免费数据库,是学习和构建桌面及小型服务器数据驱动应用程序的理想选择。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 ServerSQL Server Express 无缝升级到其他更高端的 SQL ServerSQL Server版本。If you need more advanced database features, SQL ServerSQL Server Express can be seamlessly upgraded to other higher end versions of SQL ServerSQL Server. SQL ServerSQL 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 ServerSQL Server 用于 Internet 服务器Using SQL ServerSQL Server with an Internet Server

在 Internet 服务器(如运行 Internet Information Services (IIS) 的服务器)上通常都会安装 SQL ServerSQL Server 客户端工具。On an Internet server, such as a server that is running Internet Information Services (IIS), you will typically install the SQL ServerSQL Server client tools. 客户端工具包括连接到 SQL ServerSQL Server实例的应用程序所使用的客户端连接组件。Client tools include the client connectivity components used by an application connecting to an instance of SQL ServerSQL Server.

备注

尽管可以在运行 IIS 的计算机上安装 SQL ServerSQL Server 实例,但这种做法通常只用于仅包含一台服务器的小型网站。Although you can install an instance of SQL ServerSQL 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 ServerSQL Server 用于客户端/服务器应用程序Using SQL ServerSQL Server with Client/Server Applications

在运行直接连接到 SQL ServerSQL Server 实例的客户端/服务器应用程序的计算机上,只能安装 SQL ServerSQL Server客户端组件。You can install just the SQL ServerSQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL ServerSQL Server. 如果要在数据库服务器上管理 SQL ServerSQL Server 实例,或者打算开发 SQL ServerSQL Server 应用程序,那么客户端组件安装也是一个不错的选择。A client components installation is also a good option if you administer an instance of SQL ServerSQL Server on a database server, or if you plan to develop SQL ServerSQL Server applications.

客户端工具选项安装以下 SQL ServerSQL Server 功能:向后兼容性组件、 SQL Server Data ToolsSQL Server Data Tools、连接组件、管理工具、软件开发包和 SQL ServerSQL Server 联机丛书组件。The client tools option installs the following SQL ServerSQL Server features: backward compatibility components, SQL Server Data ToolsSQL Server Data Tools, connectivity components, management tools, software development kit, and SQL ServerSQL Server Books Online components. 有关详细信息,请参阅从安装向导安装 SQL Server 2014(安装程序)For more information, see Install SQL Server 2014 from the Installation Wizard (Setup).

选择 SQL ServerSQL Server 组件Deciding Among SQL ServerSQL Server Components

使用 SQL ServerSQL Server 安装向导的“功能选择”页面选择安装 SQL ServerSQL Server时要安装的组件。Use the Feature Selection page of the SQL ServerSQL Server Installation Wizard to select the components to include in an installation of SQL ServerSQL 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 DescriptionDescription
SQL Server 数据库引擎SQL Server Database Engine SQL Server 数据库引擎SQL Server Database Engine 包括数据库引擎Database Engine(用于存储、处理和保护数据安全的核心服务)、复制、全文搜索、用于管理关系数据和 XML 数据的工具以及 “数据库引擎服务”Data Quality Services (DQS) 服务器。includes the 数据库引擎Database 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 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 ServicesIntegration ServicesIntegration Services(DQS) 组件。It also includes the “数据库引擎服务”Data Quality Services (DQS) component for Integration ServicesIntegration Services.
Master Data ServicesMaster Data Services Master Data ServicesMaster Data Services (MDS) 是针对主数据管理的 SQL ServerSQL Server 解决方案。(MDS) is the SQL ServerSQL Server solution for master data management. 可以配置 MDS 来管理任何领域(产品、客户、帐户);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 DescriptionDescription
SQL Server Management StudioSQL Server Management Studio SQL Server Management StudioSQL Server Management Studio 是用于访问、配置、管理和开发 SQL ServerSQL Server组件的集成环境。is an integrated environment to access, configure, manage, administer, and develop components of SQL ServerSQL Server. Management StudioManagement Studio 使各种技术水平的开发人员和管理员都能使用 SQL ServerSQL Serverlets developers and administrators of all skill levels use SQL ServerSQL Server.
SQL ServerSQL Server 配置管理器Configuration Manager SQL ServerSQL Server 配置管理器为 SQL ServerSQL Server 服务、服务器协议、客户端协议和客户端别名提供基本配置管理。Configuration Manager provides basic configuration management for SQL ServerSQL Server services, server protocols, client protocols, and client aliases.
SQL Server ProfilerSQL Server Profiler SQL Server ProfilerSQL Server Profiler 提供了一个图形用户界面,用于监视 数据库引擎Database Engine 实例或 Analysis ServicesAnalysis Services实例。provides a graphical user interface to monitor an instance of the 数据库引擎Database Engine or Analysis ServicesAnalysis Services.
数据库引擎Database Engine 优化顾问Tuning Advisor 数据库引擎Database Engine 优化顾问可以协助创建索引、索引视图和分区的最佳组合。Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
数据质量客户端Data 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 ServerSQL Server 平台(包括本地和外部)执行其所有数据库设计工作。also includes "Database Projects", which provides an integrated environment for database developers to carry out all their database design work for any SQL ServerSQL 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 DescriptionDescription
SQL ServerSQL Server 联机丛书Books Online SQL ServerSQL Server的核心文档。Core documentation for SQL ServerSQL Server.

请参阅See Also

计划 SQL Server 安装 Planning a SQL Server Installation
从安装向导安装 SQL Server 2014(安装程序)Install SQL Server 2014 from the Installation Wizard (Setup)