Earlier I had written on migrating your Northwind database from SQL Server to SQL Azure. In that, I had mentioned that the SQL Azure Migration Wizard supports migrating the schema and doesn’t do the data migration which has to be done manually.
Meanwhile, George Huey has published a recent version on the SQL Azure Migration Wizard at CodePlex which also does data migration. What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along with data into your SQL Azure Database. That’s one hell of work done in a single step, I would say.
What’s more, the recent version also supports the following options
SQL Server to SQL Azure (existing)
SQL Azure to SQL Server
SQL Azure to SQL Azure (multiple accounts)
You can download the latest version from http://sqlazuremw.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=32334
Cheers !!!