Using the SQL to Azure Migration Wizard

This document shows how to use the SQL to Azure Migration Wizard.

The wizard enables you to copy a database from SQL Server to Windows Azure.

This document was prepared for the Fall 2012 version of the Web Services course. Its usefulness may not extend beyond that specific course.

.

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:

  1. Signed up for a Windows Azure free trial
  2. Created a web site for your app
  3. Created a database for your app

.

Running the wizard

Run the SQLAzureMW application. Its initial screen opens:

SAMW 1

.

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:

SAMW 2

.

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.

SAMW 3a

.

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

SAMW 4a

.

SAMW 5a

.

SAMW 6

.

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:

SAMW 8

.

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:

SAMW 9

.

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

SAMW 10a

.

Ready?

SAMW 11

.

Your data will be copied to your Windows Azure database.

SAMW 12

.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: