Tuesday, April 9, 2013

It's like SQL Import Export wizard... only it actually WORKS

Getting data into Amazon RDS http://aws.amazon.com/rds/
This tool does ALL the work for you: http://sqlazuremw.codeplex.com/ 
Its a GUI wrapper for the BCP utility. It will generate all objects, store the objects and the data as local files, then it will import everything to your target RDS server in the correct order (always a pain to do manually with PK's / FK's). It's designed with Azure in mind, but allows selection of SQL Server and it works!

No comments: