1) To migrate a SQL DB to a DB on an Azure VM. In SSMS, rt click DB > Tasks > Deploy to Azure VM.
2) This is easy method to migrate databases from SQL Server to the Azure SQL database (not Azure VM). Note: This is for website, not VM.
DOWNLOAD: http://sqlazuremw.codeplex.com/
VIDEO that shows how to use the migration tool (pretty easy to use).
http://channel9.msdn.com/posts/SQL-Azure-Migration-Wizard-Part-2-Using-the-SQL-Azure-Migration-Wizard
Key points:
- during wizard steps, click Advanced to choose "schema with data" to generate a script that includes the data
- in the connection string, for user, need to add user@servername
