Using the SQL to Azure Migration Wizard

Get the wizard

Visit the project’s web site on CodePlex:

http://sqlazuremw.codeplex.com/

You can download the zip package (version 3.x, for SQL Server 2008) to a folder on your desktop if you wish. Then, un-zip the package into a folder.

Scenario for the Fall 2012 version of the Web Services course

This scenario assumes that your web service app uses a database on your computer’s SQL Server Express instance.

It also assumes that your app is complete, works well, and is ready to deploy.

It also assumes that you have:

Signed up for a Windows Azure free trial
Created a web site for your app
Created a database for your app

Running the wizard

Run the SQLAzureMW application. Its initial screen opens:

Select as shown above, and click “Next >”. The “Connect to Server…” dialog appears. It’s asking for connection information for your local computer’s SQL Server Express instance. So, make sure that you enter the “Server name:” as shown:

On the next screen, all of your local computer’s databases are shown in a list. Select/highlight the “source” database, and click the “Next >” button.

Click through the next three dialogs, because we want all database objects etc.:

The wizard will run, and should report “Done!”. Click the “Next >” button.

On the Windows Azure portal, click/select the destination database. On the lower-right area of the screen, you will see “quick glance” information about the database:

You need the server name for the next dialog, which shows settings for the Windows Azure destination database. Append “,1433” (comma, then 1433) to the “SERVER NAME”, and enter it into the dialog’s “Server name:” field:

Next, you will see a list of destination databases. Click to select one, and then click “Next >”.

Ready?

Your data will be copied to your Windows Azure database.

Peter McIntyre