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.
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
2.2. Source database tasks
Enter source SQL Server database connection details and click
Select datababase to be migrate on AWS RDS from the list of databases and click
Select “Script all database objects” option to migrate complete database or you can use second option to migrate selected objects only and click
Review the list of selected objects to be migrate and click
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
2.3. Destination database tasks
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
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.