本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。
# 在 Amazon EC2 和 Amazon RDS 之間進行選擇
Amazon EC2 和 Amazon RDS 提供的獨特優勢可能對您的特定使用案例有益。根據您的需求，您可以靈活地為 SQL Server 資料庫使用一個或兩個服務。本節提供詳細資訊，協助您進行選擇。
## 決策矩陣
下表提供 Amazon RDS、Amazon RDS Custom for SQL Server 和 Amazon EC2 上支援的 SQL Server 功能的side-by-side比較。使用此資訊了解其差異，並為您的使用案例選擇最佳方法。
如需 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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| `BULK INSERT` | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (Enterprise Edition：所有版本；Standard Edition：2016 SP1 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 資料欄存放區索引 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (Enterprise 和 Standard Editions：2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (Enterprise 和 Standard Editions：2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (Enterprise Edition：2014 及更新版本；Standard Edition：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)。 |
| Data Quality Services | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 資料庫郵件 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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 資源的傳出電子郵件，以確保高度的可交付性。 |
| 資料庫引擎調校 Advisor | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 資料庫事件通知 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 交易耐久性延遲 （延遲遞交） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| 分散式查詢 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 目標） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 目標） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 延伸預存程序，包括 `xp_cmdshell` | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 檔案資料表 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| `FILESTREAM` | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | `FILESTREAM` 與 Amazon RDS 不相容。不過，您可以設定記憶體內資料庫。 |
| 全文檢索搜尋 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （語意搜尋除外） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 記憶體資料庫 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| 連結伺服器 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server、Oracle 和 Teradata 目標） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是，搭配 CEV | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 請參閱《[Amazon RDS for SQL Server 文件》中的使用 Amazon RDS for SQL Server 實作連結的](https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/)[伺服器部落格文章和使用 Oracle OLEDB 支援連結的伺服器](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.LinkedServers_Oracle_OLEDB.html)。 自訂引擎版本 (CEV) 是資料庫版本和 Amazon Machine Image (AMI) 的二進位磁碟區快照。 |
| Machine Learning Services （使用 R 指令碼） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | Machine Learning Services 必須單獨安裝在 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 （請參閱部落格文章 [R on 入門 AWS](https://aws.amazon.com/blogs/opensource/getting-started-with-r-on-amazon-web-services/))。 |
| 維護計劃 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | Amazon RDS 提供一組單獨的功能，以促進資料庫的備份和復原。對於備份，您可以設定自動備份。 |
| Master Data Services | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| Microsoft Distributed Transaction Coordinator (MSDTC) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 部分包含的資料庫 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| 效能資料收集器 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 在 Amazon RDS 上，您可以使用 Amazon CloudWatch AWS CloudTrail和績效詳情來監控 SQL Server 效能 （請參閱 [Amazon RDS 文件中的監控 Amazon RDS 概觀](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MonitoringOverview.html))。 |
| 政策型管理 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| PolyBase | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 預先設定的參數 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | |
| 資源管理員 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 安全 CLR | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016、2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 序列 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| 伺服器層級觸發程序 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| Service Broker | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （端點除外） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 空間和位置功能 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 代理程式 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 分析服務 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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 整合服務 (SSIS) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 遷移助理 (SSMA) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server Profiler | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （伺服器端和用戶端追蹤） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| `sqlcmd` | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 延展資料庫 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| `THROW` 陳述式 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| Transact-SQL 端點 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| WCF 資料服務 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （僅用於遷移） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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 容錯移轉叢集執行個體 (FCIs) | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 您可以使用 AWS Launch Wizard 簡化 Amazon EC2 上的 SQL Server FCI 部署。請參閱 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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | Amazon RDS 使用完整備份檔案 (.bak 檔案） 和 Amazon S3 做為儲存庫，支援 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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 複寫 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 （有限推送訂閱） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （僅限遷移） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 日誌傳送 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 基於災難復原目的，您可以使用僅供讀取複本或 [AWS DMS](https://aws.amazon.com/dms/)。 |
| 自訂日誌運送 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 不適用 | |
| 受管自動化備份 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （儲存型複寫） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （僅限 Enterprise Edition，手動設定 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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （搭配 Always On 可用性群組的手動組態） | |
| `RESTORE` 命令 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 （將您自己的指標匯出至 Amazon CloudWatch 或使用第三方解決方案） | ![\[No\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 每個執行個體的資料庫數目上限 | 取決於執行個體大小和多可用區組態 | SQL Server 上限 (5000) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 無限制 | Amazon RDS 也使用非揮發性 Memory Express (NVMe) 執行個體儲存體，在本機磁碟上支援 tempdb 資料庫。請參閱 [Amazon RDS 文件中的 Amazon RDS for SQL Server 上 tempdb 資料庫的執行個體存放區支援](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.InstanceStore.html)。 |
| 資料庫執行個體的最小儲存體大小 | 20 GiB (Enterprise、Standard、Web 和 Express Edition) | 20 GiB (Enterprise、Standard、Web 和 Express Edition) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 無限制 | |
| 新的查詢最佳化工具 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 (CEV) ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (RPEV) | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | 自訂引擎版本 (CEV) 是資料庫版本和 Amazon Machine Image (AMI) 的二進位磁碟區快照。RDS 提供的引擎版本 (RPEV) 是預設的 Amazon Machine Image (AMI) 和 Microsoft SQL Server 安裝。 |
| 使用 加密的儲存 AWS KMS | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2016 及更新版本） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2014 及更新版本） | |
| SQL 身分驗證 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SQL Server 稽核 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| SSL （傳輸中加密） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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)。 |
| sysadmin 角色 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （企業版：2016-2022；標準版：2019 和 2022) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (SQL Server 2019 和 2022 Enterprise、Standard、Web 和 Developer Edition) | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 (Enterprise Edition：2014-2019；Standard Edition：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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 重新命名現有資料庫的能力 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 （僅限單一可用區） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 自訂設定時區 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | |
| 分散式重播 | ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | SQL Server 分散式重播用戶端服務[需要 sysadmin 許可](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_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png) 是 | 如果此功能對您的工作負載至關重要，請考慮選擇 Amazon RDS Custom 或 Amazon EC2。 |
| 安裝方法 | N/A | N/A | Amazon Machine Image (AMI) 或手動安裝 | |
| SQL Server 版本 | Enterprise、Standard、Web、Express | 企業、標準、開發人員 | Enterprise、Standard、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 參考架構：在 上實作 Active Directory 網域服務 AWS](https://aws.amazon.com/windows/resources/whitepapers/#ad)
+ [在 上保護 Microsoft 平台 AWS](https://d1.awsstatic.com/whitepapers/aws-microsoft-platform-security.pdf)
+ [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_tw/prescriptive-guidance/latest/migration-sql-server/images/shared-responsibility.png)
透過 AWS 服務，您不必擔心管理任務，例如伺服器佈建、修補、設定、組態、備份或復原。 AWS 會持續監控您的叢集，以使用自我修復儲存和自動擴展來保持工作負載正常運作。您專注於高價值的應用程式開發任務，例如結構描述設計、查詢建構和最佳化，同時代您 AWS 處理操作任務。
您永遠不需要過度佈建或佈建不足的基礎設施來適應應用程式成長、間歇性尖峰和效能需求，或產生固定的資本成本，包括軟體授權和支援、硬體重新整理，以及維護硬體的資源。 會 AWS 管理這些成本，因此您可以花時間創新和建立新應用程式，而不是管理基礎設施。
如需詳細資訊，請參閱 AWS 網站上的[共同責任模型](https://aws.amazon.com/compliance/shared-responsibility-model/)。