Over the last few weeks I have, amongst other things, been migrating an n-tiered ASP.NET 3.5/SQL 2005 solution to Windows Azure. Usually when I hear the “migration” word I curl into a fetal position and start rocking in a dark corner but I finally had a chance to move the last of a set of solutions I manage to Azure so I was more relieved than anything.
After working through a number of ASP.NET migration issues, i.e. migrating over to the Azure session state provider and caching service, etc. I could finally see light at the end of the tunnel. I wasn’t overly concerned about the SQL migration as my database wasn’t overly complex in the scheme of things. The following post is a collection of steps I followed to successfully migrate the SQL database to the cloud. Continue reading