BT

Your opinion matters! Please fill in the InfoQ Survey!

SQLAzureMW Migrates SQL Databases to SQL Azure

| by Abel Avram Follow 4 Followers on Sep 03, 2009. Estimated reading time: 1 minute |

The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.

After selecting an SQL 2005 or 2008 database, SQLAzureMW iterates through its tables, stored procedures, and views allowing the user to select which SQL objects are to be processed, then it offers 3 options on what to do next:

  1. Script to window - Choose this option to display the SQL script to a wizard window where you can modify it before telling the wizard to script to Azure.
  2. Script to file - Choose this option if you want to save your SQL script to a file. You can edit this file in SQL Server Management Studio and run it from there or save it and use the wizard to load and run your file.
  3. Script to Azure - Choose this option is you think your database is compatible with SQL Azure. It will prompt your for your Azure credentials and then run the generated script against SQL Azure.

SQLAzureMW takes care of the incompatibilities between SQL 2005/2008 and SQL Azure. For example, text columns are transformed into varchar(max) columns, image ones are turned into varbinary(max) ones, and it unbinds XML schemas since they are not supported yet by SQL Azure. These transformations and changes to the script are stored in an XML configuration file, NotSupportedByAzureFile.config. This supports changing the way the script is generated when SQL Azure is updated with new functionality.

SQLAzureMW is currently an Alpha release v.0.2, released under Microsoft Public License (Ms-PL). SQLAzureMW  is a VS 2008 project and .NET 3.5 SP1 is needed to run it.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT