本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。

# SQL Server 資料庫遷移方法
<a name="methods"></a>

遷移 SQL Server 資料庫的方法有多種 AWS。您可以根據您的評估和需求，從 AWS 服務和 SQL Server 原生功能中進行選擇。本節說明一些最常見的方法，這些方法摘要在下列兩個資料表中。本指南稍後的 Amazon EC2 和 Amazon RDS 章節中包含部分這些方法的詳細討論。

**AWS 服務**


****  

| 遷移方法 | Target | 功能和限制 | 其他資訊 | 
| --- | --- | --- | --- | 
| **AWS DMS** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom<br />Amazon Aurora | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [AWS DMS](heterogeneous-migration-tools.md#aws-dms) 區段 | 
| **AWS Migration Hub Orchestrator** | Amazon EC2<br />Amazon RDS | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [AWS Migration Hub Orchestrator](mho.md) 區段 | 
| **AWS Application Migration Service** | Amazon EC2 | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵蓋 （請參閱 [Application Migration Service 文件](https://docs.aws.amazon.com/mgn/index.html)) | 
| **AWS Snowball Edge** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [Snowball Edge](snowball-edge.md) 區段 | 

**SQL Server 原生方法**


****  

| 遷移方法 | Target | 功能和限制 | 其他資訊 | 
| --- | --- | --- | --- | 
| **原生備份和還原** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [原生 SQL Server 備份/還原](native-backup-restore.md)區段 （您可以使用 [AWS Migration Hub Orchestrator](mho.md)來自動化原生備份和還原） | 
| **日誌傳送** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [日誌運送](log-shipping.md)區段 | 
| **自訂日誌運送** | Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [使用自訂日誌運送將內部部署或 Amazon EC2 SQL Server 自動化至 Amazon RDS for SQL Server 遷移](https://aws.amazon.com/blogs/database/automate-on-premises-or-amazon-ec2-sql-server-to-amazon-rds-for-sql-server-migration-using-custom-log-shipping/) (AWS 部落格文章） | 
| **資料庫鏡像** | Amazon EC2 | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [資料庫鏡像](db-mirroring.md)區段 | 
| **Always On 可用性群組** | Amazon EC2<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [Always On 可用性群組](always-on.md)區段 | 
| **Basic Always On 可用性群組** | Amazon EC2 | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵蓋 （請參閱 Microsoft 文件中[單一資料庫的基本 Always On 可用性群組](https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups)) | 
| **分散式可用性群組** | Amazon EC2<br />Amazon RDS Custom （僅限遷移） | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [分散式可用性群組](distributed-groups.md)區段 | 
| **交易式複寫** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | [交易複寫](trans-rep.md)區段 | 
| **大量複製程式 (bcp)** | Amazon EC2<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵蓋 （請參閱《Amazon RDS 文件》中的[使用其他方法大量複製一節匯入和匯出 SQL Server 資料](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html)) **  | 
| **分離並連接** | Amazon EC2<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵蓋 （請參閱 Microsoft 文件中的[資料庫分離和連接](https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-detach-and-attach-sql-server)) | 
| **匯入/匯出** | Amazon EC2<br />Amazon RDS<br />Amazon RDS Custom | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵蓋 （請參閱《Amazon RDS 文件》中的[使用其他方法匯入和匯出 SQL Server 資料](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html#SQLServer.Procedural.Exporting.SSIEW)) |