本文属于机器翻译版本。若本译文内容与英语原文存在差异，则一律以英文原文为准。
# 在 Amazon EC2 和 Amazon RDS 之间进行选择
Amazon EC2 和 Amazon RDS 具有独特的优势，可能对您的特定用例有益。您可以根据自己的需要，灵活地为 SQL Server 数据库使用一种或两种服务。本节提供了详细的信息来帮助您做出选择。
## 决策矩阵
下表并排比较了 Amazon RDS、Amazon RDS Custom for SQL Server 和 Amazon EC2 支持的 SQL Server 功能。使用这些信息来了解它们之间的差异，并为您的用例选择最佳方法。
有关 Amazon RDS 的最新信息，请参阅 AWS 文档中的 [Amazon RDS 上的 Microsoft SQL Server](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html)。
------
#### [ Development ]
****
| 开发功能 | Amazon RDS | Amazon RDS Custom | Amazon EC2 | 备注 |
| --- | --- | --- | --- | --- |
| 缓冲池扩展 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| `BULK INSERT` | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[将 Amazon RDS for SQL Server 数据库实例与 Amazon S3 集成](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html)。 |
| 更改数据捕获 (CDC) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版：所有版本；标准版：2016 SP1 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[使用更改数据捕获](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html)。 |
| 更改跟踪 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| Columnstore 索引 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版和标准版：2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版和标准版：2019 和 2022） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版：2014 及更高版本；标准版：2016 SP1 及更高版本） | 请参阅 SQL Server 文档中的 [RDBMS 可扩展性和性能](https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#RDBMSSP)。 |
| 数据质量服务 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 数据库邮件 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅博客帖子[在 Amazon RDS for SQL Server 上使用数据库邮件](https://aws.amazon.com/blogs/database/using-database-mail-on-amazon-rds-for-sql-server/)。 我们鼓励您使用 [Amazon Simple Email Service (Amazon SES)](https://aws.amazon.com/ses/) 发送源自 AWS 资源的出站电子邮件，以确保高度的送达率。 |
| 数据库引擎优化顾问 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 数据库事件通知 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（手动跟踪和管理数据库事件） | 请参阅 Amazon RDS 文档中的[使用 Amazon RDS 事件通知](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html)。 |
| DDL 事件通知 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 延迟事务持久性（延迟提交） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019 及 2022） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| 分布式查询 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 目标） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 目标） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 目标） | 请参阅[使用 Amazon RDS for SQL Server 实施链接服务器](https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/)博客文章。 |
| 扩展事件 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 扩展存储过程，包括 `xp_cmdshell` | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 文件表 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| `FILESTREAM` | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | `FILESTREAM` 与 Amazon RDS 不兼容。但是，您可以配置内存数据库。 |
| 全文搜索 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（语义搜索除外） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 内存数据库 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| 链接服务器 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server、Oracle 和 Teradata 目标） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是，使用 CEV | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[使用 Amazon RDS for SQL Server 实现链接服务器](https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/)博客文章和[在 Amazon RDS for SQL Server 中使用 Oracle OLEDB 支持链接服务器](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.LinkedServers_Oracle_OLEDB.html)。 自定义引擎版本（CEV）是数据库版本和亚马逊机器映像（AMI）的二进制卷快照。 |
| 机器学习服务（使用 R 脚本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 机器学习服务必须单独安装在 Windows 或 Linux 计算机上。仅在 SQL Server 2019 及更高版本中，[Always On 失效转移群集实例 (FCI)](https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-ver15) 才支持该功能。 尽管 Amazon RDS 不支持 R 脚本，但您可以在 AWS 上使用它（请参阅博客文章 [AWS 上的 R 脚本入门](https://aws.amazon.com/blogs/opensource/getting-started-with-r-on-amazon-web-services/)）。 |
| 维护计划 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | Amazon RDS 提供了一组单独的功能，以方便数据库的备份和恢复。对于备份，您可以配置自动备份。 |
| 主数据服务 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| Microsoft 分布式事务处理协调器 (MSDTC) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅博客文章[为加入域的 Amazon RDS for SQL Server 实例启用分布式事务支持](https://aws.amazon.com/blogs/database/enabling-distributed-transaction-support-for-domain-joined-amazon-rds-for-sql-server-instances/)。 |
| `OPENROWSET` | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 部分包含的数据库 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| 性能数据收集器 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 在 Amazon RDS 上，您可以使用 Amazon CloudWatch、AWS CloudTrail 和 Performance Insights 监控您的 SQL Server 性能（请参阅 Amazon RDS 文档中的[监控 Amazon RDS 概述](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MonitoringOverview.html)）。 |
| 基于策略的管理 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| PolyBase | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 预配置参数 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | |
| 资源管理器 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 安全 CLR | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016、2019 及 2022 版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 序列 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| 服务器级别触发器 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 服务代理 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（端点除外） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 空间和位置特征 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server Agent | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server Analysis Services (SSAS) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[Amazon RDS for SQL Server 中对 SSAS 的支持](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSAS.html)。 |
| SQL Server Integration Services (SSIS) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[Amazon RDS for SQL Server 中对 SSIS 的支持](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSIS.html)。 |
| SQL Server Reporting Services (SSRS) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的 [Amazon RDS for SQL Server 中对 SSRS 的支持](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSRS.html)。 |
| SQL Server Management Studio (SSMS) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 迁移助手 (SSMA) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 启动 SQL Server Profiler | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（服务器端和客户端跟踪） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| `sqlcmd` | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 拉伸数据库 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| `THROW` statement | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| Transact-SQL 端点 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 所有使用 `CREATE ENDPOINT` 的操作在 Amazon RDS 上均不可用。我们建议您在 EC2 实例上安装 SQL Server 以执行这些操作。 |
| UTF-16 支持 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| WCF Data Services | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
------
#### [ HA/DR ]
****
| 开发功能 | Amazon RDS | Amazon RDS Custom | Amazon EC2 | 备注 |
| --- | --- | --- | --- | --- |
| Always On 可用性组 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（仅用于迁移目的） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果您需要一个自行管理的 Always On 可用性组，我们建议您使用 AWS Launch Wizard 来简化 EC2 实例上的 SQL Server HA 部署。请参阅 AWS 文档中的 [AWS Launch Wizard for SQL Server](https://docs.aws.amazon.com/launchwizard/latest/userguide/launch-wizard-sql.html)。 |
| Always On 失效转移群集实例 (FCI) | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 您可以使用 AWS Launch Wizard 简化 SQL Server FCI 在 Amazon EC2 上的部署。请参阅 AWS 文档中的 [AWS Launch Wizard for SQL Server](https://docs.aws.amazon.com/launchwizard/latest/userguide/launch-wizard-sql.html)。 |
| 备份到 Amazon S3 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | Amazon RDS 支持使用差异备份或完整备份文件（.bak 文件）对 Microsoft SQL Server 数据库进行本机备份和还原。请参阅 Amazon RDS 文档中的[导入和导出 SQL Server 数据库](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html)。 |
| `BACKUP` 命令 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 AWS 知识中心中的[如何对运行 SQL Server 的 Amazon RDS 数据库实例执行本机备份](https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/)。 |
| 数据库镜像 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 复制 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（限量推送订阅） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果您想在 Amazon RDS 上复制单个表，也可以使用 [AWS DMS](https://aws.amazon.com/dms/) 或设置只读副本。 |
| 分布式可用性组 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（仅限迁移） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 日志传送 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 出于灾难恢复目的，您可以使用只读副本或 [AWS DMS](https://aws.amazon.com/dms/)。 |
| 自定义日志传送 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 不适用 | |
| 托管自动备份 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（需要配置和管理维护计划，或使用第三方解决方案） | 请参阅 Amazon RDS 文档中的[使用备份](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html)。 |
| 具有自动失效转移功能的多可用区 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（基于存储的复制） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（仅限企业版，手动配置 Always On 可用性组） | 请参阅 Amazon RDS 文档中的 [Amazon RDS for SQL Server 中的多可用区部署](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html)。 |
| 只读副本 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（手动配置 Always On 可用性组） | |
| `RESTORE` 命令 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 参阅（[AWS 知识中心](https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/)）。 |
------
#### [ Scalability ]
****
| 开发功能 | Amazon RDS | Amazon RDS Custom | Amazon EC2 | 备注 |
| --- | --- | --- | --- | --- |
| 内置实例和数据库监控和指标 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（将您自己的指标导出到 Amazon CloudWatch 或使用第三方解决方案） | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（将您自己的指标导出到 CloudWatch 或使用第三方解决方案） | 请参阅博客文章 [通过 Amazon CloudWatch 和 AWS Systems Manager 使用自定义指标来监控 SQL Server 数据库](https://aws.amazon.com/blogs/database/monitor-your-microsoft-sql-server-using-custom-metrics-with-amazon-cloudwatch-and-aws-systems-manager/)。 |
| 可配置存储大小 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 每个实例的最大数据库数量 | 取决于实例大小和多可用区配置 | SQL Server 最大值 (5000) | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 无限制 | 请参阅 Microsoft SQL Server 文档中的 [SQL Server 的最大容量规格](https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15)。 |
| 数据库实例的最大存储大小 | 64 TiB | 64 TiB | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 无限制 | Amazon RDS 还通过使用非易失性存储器快速通道 (NVMe) 实例存储支持本地磁盘上的 tempdb 数据库。请参阅 Amazon RDS 文档中的 [Amazon RDS for SQL Server 上的 tempdb 数据库的实例存储支持](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.InstanceStore.html)。 |
| 数据库实例的最小存储大小 | 20 GiB （企业版、标准版、Web 版和 Express 版） | 20 GiB （企业版、标准版、Web 版和 Express 版） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 无限制 | |
| 新查询优化程序 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019 及 2022 版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
------
#### [ Security ]
****
| 开发功能 | Amazon RDS | Amazon RDS Custom | Amazon EC2 | 备注 |
| --- | --- | --- | --- | --- |
| 自动软件修补 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否（CEV） ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（RPEV） | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | 自定义引擎版本（CEV）是数据库版本和亚马逊机器映像（AMI）的二进制卷快照。RDS 提供的引擎版本（RPEV）是默认 Amazon Machine Image（AMI）和 Microsoft SQL Server 安装。 |
| 使用 AWS KMS 加密存储 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅博客文章[使用 AWS KMS 加密保护 Amazon RDS 中的数据](https://aws.amazon.com/blogs/database/securing-data-in-amazon-rds-using-aws-kms-encryption/)。 |
| 服务器角色 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2016 及更高版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019 及 2022 版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2014 及更高版本） | |
| SQL 身份验证 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server Audit | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SSL（传输加密） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 请参阅 Amazon RDS 文档中的[将 SSL 用于 Microsoft SQL Server 数据库实例](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Concepts.General.SSL.Using.html)。 |
| 系统管理员角色 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 有关不受支持的服务器级角色，请参阅 Amazon RDS 文档中的 [Microsoft SQL Server 安全性](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport.UnsupportedRoles)。 在创建一个新的 RDS 数据库实例时，您使用的默认主用户将获得针对该数据库实例的特定权限（请参阅 Amazon RDS 文档中的[账户特权](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html)）。 |
| TDE（静态加密） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版：2016-2022；标准版：2019 和 2022） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（SQL Server 2019 和 2022：企业版、标准版、Web 版和开发人员版） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（企业版：2014-2019；标准版：2019） | 请参阅 [Amazon RDS](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.TDE.html) 和 [Amazon RDS Custom](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-reqs-limits-MS.html#custom-sqlserver-features.smk.tde) 文档中有关 TDE 支持的信息。 |
| Windows 身份验证 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
------
#### [ Other features ]
****
| 开发功能 | Amazon RDS | Amazon RDS Custom | Amazon EC2 | 备注 |
| --- | --- | --- | --- | --- |
| 能够安装第三方代理 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 能够重命名现有数据库 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（仅限单可用区） | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是（不适用于可用性组中的数据库或已启用镜像的数据库） | 有关 Amazon RDS 上的多可用区部署，请参阅 Amazon RDS 文档中的[在多可用区部署中重命名 Microsoft SQL Server 数据库](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html)。 |
| 对数据库实例和操作系统的控制 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 自定义设置时区 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 分布式回放 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | SQL Server 分布式回放客户端服务[需要系统管理员权限](https://docs.microsoft.com/en-us/sql/tools/distributed-replay/distributed-replay-security?view=sql-server-ver16#sql-server-permissions)，这就是 Amazon RDS 不支持该服务的原因。 |
| 将数据导入 msdb 数据库 | ![\[No\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能对您的工作负载至关重要，请考虑选择 Amazon RDS Custom 或 Amazon EC2。 |
| 安装方式 | 不适用 | 不适用 | Amazon 机器映像 (AMI) 或手动安装 | |
| SQL Server 版本 | 企业版、标准版、Web 版、Express 版 | 企业版、标准版、开发人员版 | 企业版、标准版、Web 版、开发人员版、Express 版 | |
| SQL Server 版本 | 2016、2017、2019、2022 | 2019、2022 | 2014、2016、2017、2019、2022 | |
------
有关这些功能的更多信息，请参阅以下：
+ [ 上的 Microsoft 产品AWS](https://aws.amazon.com/windows/products/)
+ [Active Directory 参考架构：在 AWS 上实施 Active Directory 域服务](https://aws.amazon.com/windows/resources/whitepapers/#ad)
+ [在 AWS](https://d1.awsstatic.com/whitepapers/aws-microsoft-platform-security.pdf) 上保护 Microsoft 平台
+ [AWS Directory Service](https://aws.amazon.com/directoryservice/)
+ [https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-sqlserverdbrestore.html](https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-sqlserverdbrestore.html) （AWS Systems Manager Automation Runbook，可将 Amazon S3 中存储的 SQL Server 数据库备份恢复到 EC2 Linux 实例上运行的 SQL Server 2017）
## 责任共担
下图显示了 AWS 与用户在管理 SQL Server 功能和操作方面的职责分工。
![\[Shared responsibility in the management of SQL Server features and operations\]](http://docs.aws.amazon.com/zh_cn/prescriptive-guidance/latest/migration-sql-server/images/shared-responsibility.png)
有了 AWS 服务，您就不必担心服务器配置、修补、设置、配置、备份或恢复等管理任务。AWS 可持续监控您的集群，通过自我修复存储和自动扩展保持您的工作负载正常运行。您可以专注于高价值的应用程序开发任务，例如架构设计、查询构造和优化，而 AWS 则代表您处理操作任务。
您无需为满足应用程序增长、间歇性峰值和性能要求而过多或过少配置基础设施，也无需承担固定资本成本，包括软件许可和支持、硬件更新以及维护硬件的资源。AWS 会对这些进行管理，因此您可以将时间用于创新和构建新的应用程序，而不是管理基础设施。
有关更多信息，请参阅 AWS [网站上的责任共担模式](https://aws.amazon.com/compliance/shared-responsibility-model/)。