Just thought I'd let everyone know that the Sql Azure Migration Wizard is awesome. I've used it many times now. There is a setting that specifies if data should be migrated along with the schema. I don't think I had that set the first time. I've also been using the trial version of the RedGate stuff (SQL Compare/SQL Data Compare). It works well too, but honestly I like the SAMW a little better AND it's free! The RedGate stuff is much better at comparing schemas and data though for sure, but for just moving DB's around, particularly on Azure. SAMW is the BOMB.

http://sqlazuremw.codeplex.com/