The guide, Migrating Data-Centric Applications to Windows Azure, provides detailed guidance on how to migrate data-centric applications to Windows Azure Cloud Services, as well as an introduction on how to migrate those same applications to Windows
Azure Virtual Machines. By using this guide, you will have the planning process, migration considerations, and prescriptive how to’s needed for a positive migration experience.
This guide captures best practices gleaned from the real-world engagements of CAT and the technical expertise of the SQL Database Content team and will be updated regularly to cover new learnings and additional features.
Will like to share some information with you, which might help you in deciding
2. Each Block blob can contain upto 200GB of data. Page blobs can be as large as 1TB where each page blob is divided into 512 byte pages. So if your data is more than 1TB I would suggest you to go with Block Blob.
I have not understood your third point, do you want to store the mdf ldf files in SQL Server or blob storage?