BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Quickly Migrate from SQL Server to SQL Azure

| by Jonathan Allen Follow 131 Followers on Oct 22, 2009. Estimated reading time: 1 minute |

In order to make migrating from SQL Server to SQL Azure easier, Microsoft is releasing a migration tool on CodePlex. The SQL Azure Migration Wizard will detect, and if possible, correct incompatibilities between SQL Server 2005/2008 and SQL Azure. Common problems it can fix include replacing text columns with varChar(max) and converting user-defined types to their base types. Other issues such as SQL Azure’s lack of support for hierarchyID will require manual intervention. In addition to generating scripts for deploying the migrated schema on SQL Azure, this tool will also allow you to migrate table data using BCP.

Windows Azure is Microsoft’s entry into the cloud computing market. It consists of several components including a data storage engine called SQL Azure. SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures. For access, developers can choose from ADO.NET, ODBC, or PHP.

SQL Azure is based on SQL Server 2008 at compatibility level 100. Databases running at lower compatibility levels such as 80 or 90 may be problematic. While the migration tool will catch compatibility level issues, it is highly recommend that databases be fully upgraded to level 100 prior to using the tool.

The beta version of the SQL Azure Migration Wizard is available on CodePlex under the Microsoft Public License.

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

Can Microsoft succeed in not changing the programming model for cloud? by Udayan Banerjee

Microsoft is doing their best to ensure that the developers can continue coding in the cloud without any disruption. I have my doubts - remember what happened in mobile. Cloud as a platform is different - setandbma.wordpress.com/2009/10/01/cloud-does-n...

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

1 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