BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

Quickly Migrate from SQL Server to SQL Azure

by Jonathan Allen on Oct 22, 2009 |

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.

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

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT