本文属于机器翻译版本。若本译文内容与英语原文存在差异，则一律以英文原文为准。

# 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_cn/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_cn/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_cn/prescriptive-guidance/latest/migration-sql-server/methods.html) | 本指南未涵盖（请参阅[应用程序迁移服务文档](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_cn/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_cn/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_cn/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_cn/prescriptive-guidance/latest/migration-sql-server/methods.html) | [使用自定义日志传送自动迁移本地或 Amazon EC2 SQL Server 到 Amazon RDS](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/) for SQL Server（AWS 博客文章） | 
| **数据库镜像** | Amazon EC2 | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_cn/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_cn/prescriptive-guidance/latest/migration-sql-server/methods.html) | [Always On 可用性组](always-on.md)部分 | 
| **基本 Always On 可用性组** | Amazon EC2 | [See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_cn/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_cn/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_cn/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_cn/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_cn/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_cn/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)） |