need to copy Schema and Data from local server to AWS RDS
I have SQL Server Express running a DB in a named instance for an off the shelf application. I want to move the DB to an Amazon Web Service RDS SQL Express instance. Unfortunately AWS does not allow you to do a restore from file copy. I tried using Data-tier application migraation and Export/Import process but none of them were succesfful. When you use the Export/Import, it does not copy over the schema and tried using SQLAzureMW as well but not successful. Can anyone recommend the best way or tool to copy the schema and data in this scenario.
Simplest way is probably to use "Generate Scripts" within management studio. On the third tab "Set scripting options", click the advanced button and then, depending on the version of management studio you're using, set either the option; "script data" to yes or "types of data to script" to schema and data This will put the schema out and produce a bunch of insert statements for the data