Migrate a Database-backed Web Site (and database) to Windows Azure Web Sites

Download this episode

Download Video


Many demonstrations and tutorials exist for creating a new web site hosted on Windows Azure Web Sites, but this video will walk you through the process of moving an existing site, and the site's SQL Server database, to Windows Azure. First, we'll use the SQL Server 2012 Client Tools to copy a database into Windows Azure Blob Storage. Then, the Windows Azure Portal is used to import that blob file into a new Windows Azure SQL Database. After creating a new Web Site and linking the new site to the imported database, the site is published in seconds using the Visual Studio 2012 web publishing features. If you've been wondering how you could migrate your web site to Windows Azure, this is a great place to get started.

Related Links



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      kinect dev

      Great video! Now, if I could make one small request, could we get a video on how to migrate an existing ASP.NET site using ASP.NET Membership? I have such a site and it fails on step one. SQL Server is not able to migrate the database because of incompatible features with Azure. I suspect the SQL Azure Migration Wizard might do a better job but it still shows some errors. It's little gotchas like these that keep me from migrating all my sites to Azure.

    • User profile image

      That's a great suggestion, Kinect Dev. I'll see what I can do about getting that up and running for you. I know my colleague Scott Klein (@sqlscott) was working on something related to P&M, so he may have something coming up in the SQL Server are of the Windows Azure content videos on Channel 9.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.