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:
- 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.
.