Migrating to SQL Server Azure

I have recently migrated a production database to SQL Azure. I used the following tool :

SQL Azure Migration Wizard v3.63

http://sqlazuremw.codeplex.com/

The reason why you have to use the wizard is because SQL Azure does not contain some syntax that normal SQL Server 2008 R2 contains. Unless you want to sit there and change every creation script that you made prior to Azure (like what I did for 2 days :( ) I suggest you use the tool. The migration wizard will go through your database and create "CREATE" and "INSERT" scripts for you. You are allowed to run the scripts manually or use the tool again to insert and create the database for you. I choose to do the entire path.

After the wizard was complete I logged back into the SQL Azure portal and copied the Data Source key and used it in our application and BAM it worked.