Amazon RDS - Backup
FAQ: It is possible to create a backup of a database running on an Amazon RDS instance and restore it on a local machine?
1. You can’t currently create a .bak file out of amazon rds.
2. Use the Azure migration wizard with amazon rds to copy the RDS database to the ec2 instance/Local server.
Once that is done you can create a .bak file from the SQL Server running on the EC2 instance. if you have the bandwidth or your database is small you may be able to use the migration tool directly on your target machine.
You can create a backup locally from AWS RDS. Using SQL Management Studio, right-click your database > Task > Export Data
----Import/Export wizard or Bulk Copy Program (BCP) for SQL Server
1) By using SQLAzureMW Tool
2) For databases of 1 GB or larger, it is more efficient to script only the database schema and then use the Import and Export Wizard or the bulk copy feature of SQL Server to transfer the data.
Backup using SQLAzureMW Tool
BCP Script which is automatically generated.
Amazon RDS -Restore
Apply script to target server.