BT

InfoQ Homepage News Quickly Migrate from SQL Server to SQL Azure

Quickly Migrate from SQL Server to SQL Azure

Bookmarks

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

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

Community comments

  • Can Microsoft succeed in not changing the programming model for cloud?

    by Udayan Banerjee /

    Your message is awaiting moderation. Thank you for participating in the discussion.

    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

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

BT

Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
Country/Zone:
State/Province/Region:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.