Brian Keating's Tech Blog

Migrate SqlServer DB to Azure Sql

December 27, 2011

Here’s one way to migrate your SqlServer Database to the Azure platform.

  1. Get the SQL Azure Migration Wizard http://sqlazuremw.codeplex.com/

  1. Start the wizard and select SQL Database Migrate option

  1. Select your source database

  1. Choose the objects you wish to migrate (all in my case)

  1. See the results and review the SQL Script if necessary.

  1. Now we need Sql Azure in the cloud for the next part, log into your http://windows.azure.com account (get a 3 month free trial if you don’t have one)

Select your Azure Server and create a new database.

  1. You’ll be prompted to select where you want your server located if you don’t already have one.

  1. Add some rules to your database, you’ll need to do this to allow access for MS Services and Visual Studio

  1. So now that you have a database in the cloud you’ll need to continue with your migration wizard by selecting this database.

  1. That’s pretty much it. Hope these screenshots helps someone out.