15支持哪些数据库版本 tfs_版本和支持的功能 - SQL Server 2016 | Microsoft Docs

最新推荐文章于 2022-11-25 16:21:34 发布

达拉崩吧叭叭叭

最新推荐文章于 2022-11-25 16:21:34 发布

阅读量305

点赞数

文章标签： 15支持哪些数据库版本 tfs

本文链接：https://blog.csdn.net/weixin_36487107/article/details/112810127

版权

SQL Server 2016 的各版本和支持的功能Editions and supported features of SQL Server 2016

07/22/2020

本文内容

适用于：Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本适用于：Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later

本主题详细介绍 SQL Server 各个版本支持的功能。This topic provides details of features supported by the SQL Server editions.

若要了解其他版本，请参阅：For information about other versions, see:

根据应用程序的需要，安装要求会有所不同。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.

可在 180 天的试用期内使用 SQL Server 评估版。The SQL Server Evaluation edition is available for a 180-day trial period.

有关最新的发布说明和新增功能的信息，请参阅以下内容：For the latest release notes and what's new information, see the following:

试用 SQL Server！Try SQL Server!

SQL ServerSQL Server 版本Editions

下表介绍 SQL ServerSQL Server的各个版本。The following table describes the editions of SQL ServerSQL Server.

SQL ServerSQL Server 版本edition

定义Definition

EnterpriseEnterprise

作为高级版本，SQL ServerSQL Server Enterprise 版提供了全面的高端数据中心功能，性能极为快捷、虚拟化不受限制，还具有端到端的商业智能，可为关键任务工作负荷提供较高服务级别，支持最终用户访问深层数据。The premium offering, SQL ServerSQL Server 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.

StandardStandard

SQL ServerSQL Server 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.

WebWeb

对于 Web 主机托管服务提供商和 Web VAP 而言，SQL ServerSQL Server Web 版本是一项总拥有成本较低的选择，它可针对从小规模到大规模 Web 资产等内容提供可伸缩性、经济性和可管理性能力。SQL ServerSQL Server 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.

开发人员Developer

SQL ServerSQL Server 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 是构建 SQL ServerSQL Server 和测试应用程序的人员的理想之选。Developer is an ideal choice for people who build SQL ServerSQL Server and test applications.

Express 版本Express editions

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 的所有可编程性功能，但在用户模式下运行，还具有零配置快速安装和必备组件要求较少的特点。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. For more information, see Install SQL Server.

选择 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

说明Description

SQL Server 数据库引擎SQL Server Database Engine

SQL Server 数据库引擎SQL Server Database Engine 包括数据库引擎Database Engine、部分工具和 “数据库引擎服务”Data Quality Services (DQS) 服务器，其中引擎是用于存储、处理和保护数据、复制及全文搜索的核心服务，工具用于管理数据库分析集成中和可访问 Hadoop 及其他异类数据源的 Polybase 集成中的关系数据和 XML 数据。includes the 数据库引擎Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to Hadoop and other heterogeneous data sources, 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 Services 的 Integration 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 中可包括层次结构、各种级别的安全性、事务、数据版本控制和业务规则，以及可用于管理数据的用于 Excel 的外接程序Add-in for Excel 。MDS 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 用于 Excel 的外接程序Add-in for Excel that can be used to manage data.

R Services(数据库内)R Services (In-Database)

R Services(数据库内)R Services (In-Database) 支持在多个平台上使用可缩放的分布式 R 解决方案，并支持使用多个企业数据源(如 Linux、Hadoop 和 Teradata 等)。supports distributed, scalable R solutions on multiple platforms and using multiple enterprise data sources, including Linux, Hadoop, and Teradata.

管理工具Management tools

说明Description

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 Server。lets developers and administrators of all skill levels use SQL ServerSQL Server.

下载和安装Download and install

Management StudioManagement Studio 下载 SQL Server Management Studio 中下载并安装

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 Services、 Reporting ServicesReporting Services和 Integration ServicesIntegration Services。provides 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

说明Description

SQL ServerSQL Server 联机丛书Books Online

SQL ServerSQL Server的核心文档。Core documentation for SQL ServerSQL Server.

开发人员版和评估版Developer and Evaluation Editions

有关开发人员版和评估版支持的功能，请参阅下表中列出的 SQL Server Enterprise Edition 功能。For features supported by Developer and Evaluation editions, see features listed for the SQL Server Enterprise Edition in the tables below.

The Developer edition continues to support only 1 client for SQL Server Distributed Replay.

Scale LimitsScale Limits

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

单个实例使用的最大计算能力 - SQL Server 数据库引擎SQL Server Database Engine1Maximum compute capacity used by a single instance - SQL Server 数据库引擎SQL Server Database Engine1

操作系统支持的最大值Operating system maximum

限制为 4 个插槽或 24 核，取二者中的较小值Limited to lesser of 4 sockets or 24 cores

限制为 4 个插槽或 16 核，取二者中的较小值Limited to lesser of 4 sockets or 16 cores

限制为 1 个插槽或 4 核，取二者中的较小值Limited to lesser of 1 socket or 4 cores

单个实例使用的最大计算能力 - Analysis ServicesAnalysis Services 或 Reporting ServicesReporting ServicesMaximum compute capacity used by a single instance - Analysis ServicesAnalysis Services or Reporting ServicesReporting Services

操作系统支持的最大值Operating system maximum

限制为 4 个插槽或 24 核，取二者中的较小值Limited to lesser of 4 sockets or 24 cores

限制为 4 个插槽或 16 核，取二者中的较小值Limited to lesser of 4 sockets or 16 cores

限制为 1 个插槽或 4 核，取二者中的较小值Limited to lesser of 1 socket or 4 cores

每个 SQL Server 数据库引擎SQL Server Database Engine实例的缓冲池的最大内存Maximum memory for buffer pool per instance of SQL Server 数据库引擎SQL Server Database Engine

操作系统支持的最大值Operating System Maximum

128 GB128 GB

64 GB64 GB

1410 MB1410 MB

每个 SQL Server 数据库引擎SQL Server Database Engine实例的列存储段缓存的最大内存Maximum memory for Columnstore segment cache per instance of SQL Server 数据库引擎SQL Server Database Engine

不受限制的内存Unlimited memory

32 GB232 GB2

16 GB216 GB2

352 MB2352 MB2

SQL Server 数据库引擎SQL Server Database Engine 中每个数据库的最大内存优化数据大小Maximum memory-optimized data size per database in SQL Server 数据库引擎SQL Server Database Engine

不受限制的内存Unlimited memory

32 GB232 GB2

16 GB216 GB2

352 MB2352 MB2

每个 Analysis ServicesAnalysis Services实例利用的最大内存Maximum memory utilized per instance of Analysis ServicesAnalysis Services

操作系统支持的最大值Operating System Maximum

表格：16 GBTabular: 16 GB

MOLAP：64 GBMOLAP: 64 GB

不适用N/A

每个 Reporting ServicesReporting Services实例利用的最大内存Maximum memory utilized per instance of Reporting ServicesReporting Services

操作系统支持的最大值Operating System Maximum

64 GB64 GB

4 GB4 GB

不适用N/A

最大关系数据库大小Maximum relational database size

524 PB524 PB

10 GB10 GB

10GB10 GB

1 对于 Enterprise Edition 配合基于服务器 + 客户端访问许可证 (CAL) 的许可(对新协议不可用)，每个 SQL Server 实例的内核数上限为 20。1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. 基于内核的服务器许可模型没有限制。There are no limits under the Core-based Server Licensing model.

2 作为跨版本创建常见可编程性外围应用 (CPSA) 的一部分，适用于 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

RDBMS High AvailabilityRDBMS High Availability

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

Server Core 支持 1Server core support 1

是Yes

日志传送Log shipping

是Yes

否No

数据库镜像Database mirroring

是Yes

仅完全安全Full safety only

仅见证服务器Witness only

备份压缩Backup compression

是Yes

否No

数据库快照Database snapshot

是Yes

是 3Yes 3

AlwaysOn 故障转移群集实例Always On failover cluster instances

是Yes

1616

是Yes

支持 2 个节点Support for 2 nodes

否No

AlwaysOn 可用性组Always On availability groups

是Yes

支持最多 8 个次要副本，包括 2 个同步次要副本Up to 8 secondary replicas, including 2 synchronous secondary replicas

否No

基本可用性组 2Basic availability groups 2

否No

是Yes

支持 2 个节点Support for 2 nodes

否No

联机页面和文件还原Online page and file restore

是Yes

否No

联机索引Online indexing

是Yes

否No

联机架构更改Online schema change

是Yes

否No

快速恢复Fast recovery

是Yes

否No

镜像备份Mirrored backups

是Yes

否No

热插拔内存和 CPUHot add memory and CPU

是Yes

否No

数据库恢复顾问Database recovery advisor

是Yes

加密备份Encrypted backup

是Yes

否No

Azure 的混合备份(URL 的备份)Hybrid backup to Azure (backup to URL)

是Yes

否No

1 有关如何在 Server Core 上安装 SQL Server 的详细信息，请参阅在 Server Core 上安装 SQL Server。1 For more information on installing SQL Server on Server Core, see Install SQL Server on Server Core.

2 有关基本可用性组的详细信息，请参阅基本可用性组。2 For more information about Basic availability groups, see Basic Availability Groups.

3 作为跨版本创建常见可编程性外围应用 (CPSA) 的一部分，适用于 SQL ServerSQL Server 2016 SP1。3 Applies to SQL ServerSQL Server 2016 SP1 as part of creating a common programmability surface area (CPSA) across editions.

RDBMS Scalability and PerformanceRDBMS Scalability and Performance

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

列存储 1Columnstore 1

是Yes

是 2Yes 2

是2Yes2

内存中 OLTP 1In-Memory OLTP 1

是Yes

是 2Yes 2

是 2， 3Yes 2, 3

是 2Yes 2

Stretch DatabaseStretch Database

是Yes

永久性主内存Persistent Main Memory

是Yes

多实例支持Multi-instance support

5050

表和索引分区Table and index partitioning

是Yes

是 2Yes 2

数据压缩Data compression

是Yes

是 2Yes 2

Resource GovernorResource Governor

是Yes

否No

已分区表并行度Partitioned Table Parallelism

是Yes

否No

多个 Filestream 容器Multiple Filestream containers

是Yes

是 2Yes 2

可识别 NUMA 的大型页内存和缓冲区数组分配NUMA Aware Large Page Memory and Buffer Array Allocation

是Yes

否 4No 4

否No

缓冲池扩展Buffer Pool Extension

是Yes

否No

I/O 资源治理I/O Resource Governance

是Yes

否No

预读Read-Ahead

是Yes

否No

高级扫描Advanced Scanning

是Yes

否No

延迟持续性Delayed Durability

是Yes

1 内存中 OLTP 数据大小和列存储段缓存限制为“规模限制”部分中的版本所指定的内存量。1 In-Memory OLTP data size and Columnstore segment cache are limited to the amount of memory specified by edition in the Scale Limits section. 最大并行度是有限的。The max degrees of parallelism is limited. 对于 Standard Edition，索引生成的进程并行度 (DOP) 限制为 2 DOP，对于 Web 和 Express Edition，索引生成的进程并行度 (DOP) 限制为 1 DOP。The degrees of process parallelism (DOP) for an index build is limited to 2 DOP for the Standard Edition and 1 DOP for the Web and Express Editions. 这是指在基于磁盘的表和内存优化表上创建的列存储索引。This refers to columnstore indexes created over disk-based tables and memory-optimized tables.

2 作为跨版本创建常见可编程性外围应用 (CPSA) 的一部分，适用于 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a Common Programmability Surface Area (CPSA) across editions. 聚合下推、字符串谓词下推和 SIMD 优化是 SQL ServerSQL Server Enterprise Edition 可伸缩性增强功能。Aggregate Pushdown, String Predicate Pushdown, and SIMD Optimizations are SQL ServerSQL Server Enterprise Edition scalability enhancements. 如需了解更多详情，请参阅列存储索引 - 新变化。

3 LocalDB 安装选项中不包括此功能。3 This feature is not included in the LocalDB installation option.

4 SQL Server Standard Edition 和基于 CAL 的许可能够限制 SQL Server Standard 可使用的处理器数，但 SQL Server Standard 为 NUMA 感知。4 Standard Edition and SQL Server + CAL-based licensing can restrict how many processors SQL Server Standard can use, but SQL Server Standard is NUMA aware.

RDBMS SecurityRDBMS Security

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

ExpressExpress

Express with Advanced ServicesExpress with Advanced Services

行级安全性Row-level security

是Yes

是 1Yes 1

Always EncryptedAlways Encrypted

是Yes

是 1Yes 1

动态数据掩码Dynamic data masking

是Yes

是 1Yes 1

服务器审核Server audit

是Yes

数据库审核Database audit

是Yes

是 1Yes 1

透明数据库加密Transparent database encryption

是Yes

否No

可扩展的密钥管理Extensible key management

是Yes

否No

用户定义的角色User-defined roles

是Yes

包含的数据库Contained databases

是Yes

备份加密Encryption for backups

是Yes

否No

1 作为跨版本创建常见可编程性外围应用 (CPSA) 的一部分，适用于 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。1 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

ReplicationReplication

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

异类订阅服务器Heterogeneous subscribers

是Yes

否No

合并复制Merge replication

是Yes

支持(仅订阅服务器)Yes (Subscriber only)

Oracle 发布Oracle publishing

是Yes

否No

对等事务复制Peer to peer transactional replication

是Yes

否No

快照复制Snapshot replication

是Yes

支持(仅订阅服务器)Yes (Subscriber only)

SQL Server 变更跟踪SQL Server change tracking

是Yes

事务复制Transactional replication

是Yes

支持(仅订阅服务器)Yes (Subscriber only)

事务复制到 AzureTransactional replication to Azure

是Yes

否No

事务复制可更新的订阅Transactional replication updateable subscription

是Yes

否No

Management ToolsManagement Tools

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

SQL 管理对象 (SMO)SQL Management Objects (SMO)

是Yes

SQL 配置管理器SQL Configuration Manager

是Yes

SQL CMD(命令提示工具)SQL CMD (Command Prompt tool)

是Yes

Distributed Replay - 管理工具Distributed Replay - Admin Tool

是Yes

否No

Distributed Replay - 客户端Distribute Replay - Client

是Yes

否No

分布式重播 - 控制器Distributed Replay - Controller

支持(最多 16 个客户端)Yes (Up to 16 clients)

支持(1 个客户端)Yes (1 client)

否No

SQL ProfilerSQL Profiler

是Yes

否 1No 1

SQL Server 代理SQL Server Agent

是Yes

否No

Microsoft System Center Operations Manager 管理包Microsoft System Center Operations Manager Management Pack

是Yes

否No

数据库优化顾问 (DTA)Database Tuning Advisor (DTA)

是Yes

是 2Yes 2

否No

1 可以使用 SQL Server Standard 和 SQL Server Enterprise 版本探查 SQL Server Web、SQL Server Express、SQL Server Express with Tools 和 SQL Server Express with Advanced Services。1 SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.

2 仅对 Standard 版本功能启用优化2 Tuning enabled only on Standard edition features

RDBMS ManageabilityRDBMS Manageability

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

用户实例User instances

否No

是Yes

LocalDBLocalDB

否No

是Yes

否No

专用管理连接Dedicated admin connection

是Yes

支持(使用跟踪标志)Yes with trace flag

PowerShell 脚本支持PowerShell scripting support

是Yes

SysPrep 支持 1SysPrep support 1

是Yes

支持数据层应用程序组件操作 - 提取、部署、升级、删除Support for data-tier application component operations - extract, deploy, upgrade, delete

是Yes

策略自动执行(检查计划和更改)Policy automation (check on schedule and change)

是Yes

否No

性能数据收集器Performance data collector

是Yes

否No

能够作为多实例管理中的托管实例注册Able to enroll as a managed instance in multi-instance management

是Yes

否No

标准性能报表Standard performance reports

是Yes

否No

计划指南和计划指南的计划冻结Plan guides and plan freezing for plan guides

是Yes

否No

使用 NOEXPAND 提示的索引视图的直接查询Direct query of indexed views (using NOEXPAND hint)

是Yes

自动索引视图维护Automatic indexed views maintenance

是Yes

否No

分布式分区视图Distributed partitioned views

是Yes

否No

并行索引操作Parallel indexed operations

是Yes

否No

查询优化器自动使用索引视图Automatic use of indexed view by query optimizer

是Yes

否No

并行一致性检查Parallel consistency check

是Yes

否No

SQL Server 实用工具控制点SQL Server Utility Control Point

是Yes

否No

缓冲池扩展Buffer pool extension

是Yes

否No

Development ToolsDevelopment Tools

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

Microsoft Visual Studio 集成Microsoft Visual Studio integration

是Yes

Intellisense(Transact-SQL 和 MDX)Intellisense (Transact-SQL and MDX)

是Yes

SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)

是Yes

否No

MDX 编辑、调试和设计工具MDX edit, debug, and design tools

是Yes

否No

ProgrammabilityProgrammability

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

基本 R 集成Basic R integration

是Yes

否No

高级 R 集成Advanced R integration

是Yes

否No

R Server (Standalone)R Server (Standalone)

是Yes

否No

PolyBase 计算节点PolyBase compute node

是Yes

是 1Yes 1

是 1, 2Yes 1, 2

PolyBase 头节点PolyBase head node

是Yes

否No

JSONJSON

是Yes

查询存储Query Store

是Yes

临时Temporal

是Yes

公共语言运行时 (CLR) 集成Common Language Runtime (CLR) Integration

是Yes

本机 XML 支持Native XML support

是Yes

XML 索引XML indexing

是Yes

MERGE 和 UPSERT 功能MERGE & UPSERT capabilities

是Yes

FILESTREAM 支持FILESTREAM support

是Yes

FileTableFileTable

是Yes

日期和时间数据类型Date and Time datatypes

是Yes

国际化支持Internationalization support

是Yes

全文和语义搜索Full-text and semantic search

是Yes

否No

查询中的语言规范Specification of language in query

是Yes

否No

Service Broker(消息传递)Service Broker (messaging)

是Yes

不支持(仅客户端)No (Client only)

Transact-SQL 端点Transact-SQL endpoints

是Yes

否No

1 具有多个计算节点的 Scale out 需要一个头节点。1 Scale out with multiple compute nodes requires a head node.

Integration ServicesIntegration Services

有关 SQL ServerSQL Server 各个版本支持的 Integration Services (SSIS) 功能的信息，请参阅 SQL Server 各个版本支持的 Integration Services 功能。For info about the Integration Services (SSIS) features supported by the editions of SQL ServerSQL Server, see Integration Services Features Supported by the Editions of SQL Server.

Master Data ServicesMaster Data Services

有关 SQL ServerSQL Server 各个版本支持的 Master Data ServicesMaster Data Services 和 Data Quality Services 功能的信息，请参阅 SQL Server 各个版本支持的 Master Data Services 和 Data Quality Services 功能。For information about the Master Data ServicesMaster Data Services and Data Quality Services features supported by the editions of SQL ServerSQL Server, see Master Data Services and Data Quality Services Features Supported by the Editions of SQL Server.

Data WarehouseData Warehouse

FeatureFeature

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

在无需数据库的情况下创建多维数据集Create cubes without a database

是Yes

否No

自动生成临时和数据仓库架构Autogenerate staging and data warehouse schema

是Yes

否No

更改数据捕获Change data capture

是Yes

是 1Yes 1

否No

星型联接查询优化Star join query optimizations

是Yes

否No

可扩展的只读 Analysis Services 配置Scalable read-only Analysis Services configuration

是Yes

否No

针对已分区表和索引的并行查询处理Parallel query processing on partitioned tables and indexes

是Yes

否No

全局批处理集成Global batch aggregation

是Yes

否No

Analysis ServicesAnalysis Services

有关 SQL ServerSQL Server 各个版本支持的 Analysis Services 功能的信息，请参阅 SQL Server 各个版本支持的 Analysis Services 功能。For information about the Analysis Services features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

BI Semantic Model (Multi Dimensional)BI Semantic Model (Multi Dimensional)

BI Semantic Model (Tabular)BI Semantic Model (Tabular)

Power Pivot for SharePointPower Pivot for SharePoint

有关 SQL ServerSQL Server 各个版本支持的 Power Pivot for SharePoint 功能的信息，请参阅 SQL Server 各个版本支持的 Analysis Services 功能。For information about the Power Pivot for SharePoint features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

Data MiningData Mining

有关 SQL ServerSQL Server 各个版本支持的数据挖掘功能的信息，请参阅 SQL Server 各个版本支持的 Analysis Services 功能。For information about the Data Mining features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

Reporting ServicesReporting Services

有关 SQL ServerSQL Server 各个版本支持的 Reporting Services 功能的信息，请参阅 SQL Server 各个版本支持的 Reporting Services 功能。For information about the Reporting Services features supported by the editions of SQL ServerSQL Server, see Reporting Services Features Supported by the Editions of SQL Server.

Business Intelligence 客户端Business Intelligence Clients

Spatial and Location ServicesSpatial and Location Services

功能名称Feature Name

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

空间索引Spatial indexes

是Yes

平面和大地测量数据类型Planar and geodetic datatypes

是Yes

高级空间库Advanced spatial libraries

是Yes

导入/导出业界标准的空间数据格式Import/export of industry-standard spatial data formats

是Yes

Additional Database ServicesAdditional Database Services

功能名称Feature Name

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

SQL ServerSQL Server 迁移助手Migration Assistant

是Yes

数据库邮件Database mail

是Yes

否No

Other ComponentsOther Components

功能名称Feature Name

EnterpriseEnterprise

StandardStandard

WebWeb

Express with Advanced ServicesExpress with Advanced Services

ExpressExpress

StreamInsightStreamInsight

StreamInsight Premium EditionStreamInsight Premium Edition

StreamInsight Standard EditionStreamInsight Standard Edition

否No

StreamInsight HAStreamInsight HA

StreamInsight Premium EditionStreamInsight Premium Edition

否No

另请参阅See Also

达拉崩吧叭叭叭

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
15支持哪些数据库版本 tfs_版本和支持的功能 - SQL Server 2016 | Microsoft Docs

SQL Server 2016 的各版本和支持的功能Editions and supported features of SQL Server 201607/22/2020本文内容适用于：Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本...
复制链接

扫一扫