How to Migrate SQL Server Database to Amazon RDS Instanace

Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing to how to migrate your SQL server database to Amazon RDS instanace with easy steps. If you looks on AWS migration steps its too complicated, But windows Azure migration wizard tools provide an easier way to migrate data between local SQL Server to AWS RDS instance.

Step 1. Download SQLAzureMW Tool

1.1. At the very first we need to download SQLAzureMW using below url and extract on your system at any location.

Download SQLAzureMW tool

1.2. Use SQL Server Management Studio to connection to your local sql server and AWS RDS instanace and make sure you have proper connectivity to both server.

Step 2. Start Migration

2.1. Start Migration

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. Source database tasks

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. Destination database tasks

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.

At this step you will see that all data has been migrated to RDS SQL Server instance. Save the output showing on screen using Save button and check for errors if any.

Step 3. Verify Data

Now use your local SQL Server Management Studio and verify all your data migrated successfully or not. In case you get any errors, fix it manually.