Amazon SQL Server RDS 实例不支持从.bak文件恢复数据。因此,我将通过这篇文章来介绍如何通过简单的步骤将 SQL Server 数据库迁移到 Amazon RDS 实例。如果你看着AWS 迁移步骤它太复杂了,但是 Windows Azure 迁移向导工具提供了一种更简单的方法来将本地 SQL Server 之间的数据迁移到 AWS RDS 实例。
步骤1.下载SQLAzureMW工具
1.1.首先,我们需要使用以下网址下载 SQLAzureMW 并在系统的任何位置解压。
下载 SQLAzureMW 工具
1.2.使用 SQL Server Management Studio 连接到本地 SQL Server 和 AWS RDS 实例,并确保与这两个服务器都有正确的连接。
步骤 2. 开始迁移
2.1.开始迁移
Double click on SQLAzureMW.exe file from downloaded SQLAzureMW tool, and it will open screen like below. Select option Database and click Next.
2.2.源数据库任务
Enter source SQL Server database connection details and click Connect.
Select datababase to be migrate on AWS RDS from the list of databases and click Next.
Select “Script all database objects” option to migrate complete database or you can use second option to migrate selected objects only and click Next.
Review the list of selected objects to be migrate and click Next.
In this step wizard will create a script for all your sql server objects, Use Save button to save the script on your local hard drive and click Next to go to next step.
2.3.目标数据库任务
At this stage you have successfully created script of your database. Now input your RDS SQL Server connection details as below and click on Connect.
Select target database to which you need to migrate your data, If you do not have already created database, create new using Create Database button. Finally click Next.
到此步骤您将看到所有数据已迁移到 RDS SQL Server 实例。使用保存屏幕上显示的输出Save按钮并检查是否有错误。
步骤 3. 验证数据
现在使用您本地的SQL Server管理工作室并验证您的所有数据是否迁移成功。如果出现任何错误,请手动修复。