asked on

Script to migrate MS SQL database to Amzon SQL RDS

I have to migrate databases of many tables from MS SQL server(2008/2012) to Amazon SQL RDS. I don't have direct access to the Amazon SQL RDS. I have gone through the link

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

on how to export and import databases.

I'm looking for some command line script which takes the sql details as arguments(server, database, user pass) to migrate local sql databases to remote Amazon SQL RDS. I don't want to use sqlcmd which is very slow and not working for me. I have tried with bcp which imports & exports only tables and I could not make a script.

Anybody share their script to export the db from local sql server and import on to remote amazon sql RDS?. A bcp script can also work for me if it exports all the tables and imports all at a time. Anybody using the script to migrate the dbs over network?

ASKER CERTIFIED SOLUTION

George Khairallah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Admin Senior

ASKER

I already used SQLAzure and imported some databases. But I don't want to use the gui tool and want to save some bit of time. I'm looking for the script which I can share with others. If you have any script please share it

George Khairallah

Unfortunately, i don't have a script available for it.

If you're looking for a script for the specific database, i think the SQL azure GUI does create the corresponding bcp script. Otherwise, hopefully someone else may be able to provide a more readily available script for you.

Cheers,