From the CTO of RADSense Software

Alin Irimie

Subscribe to Alin Irimie: eMailAlertsEmail Alerts
Get Alin Irimie: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: Cloud Computing, Azure Cloud on Ulitzer, Microsoft Developer

Blog Feed Post

SQL Azure Migration Wizard

SQL Azure Migration Wizard helps you migrate your local SQL Server 2005 / 2008 databases into SQL Azure

SQL Azure Migration Wizard helps you migrate your local SQL Server 2005 / 2008 databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to edit / deploy to SQL Azure.

The SQL Azure Migration Wizard (SQLAzureMW) will let you identify a SQL Server 2005 / 2008 database that you want to migrate to SQL Azure or select an existing SQL file that has the commands you want to execute against SQL Azure.

If your source is a SQL Server database, SQLAzureMW will walk you through the different object types (i.e. Tables, Stored Procedures, Views, etc.) and let you decide which ones you want analyzed / scripted. You will be given two options:

  • Script to window / SQL Azure - 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.
  • 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.

This wizard will automatically try to make changes to your SQL Azure tables / stored procs / view (for example, text columns will become varchar(max) columns). If you have XML schema collections, it will unbind them since XML schema collections are not supported in the current version of SQL Azure. If you have UDTs defined it will replace them with base type because UDTs are currently not supported in SQL Azure. There are some things like hierarchyID that is not supported by SQL Azure and this program cannot replace automatically. In cases like this, you will have to refactor your code to use something else before you will be able to migrate to SQL Azure.

You can find SQL Azure Migration Wizard on codeplex.

Related posts:

More Stories By Alin Irimie

Alin Irimie is a software engineer - architect, designer, and developer with over 10 years experience in various languages and technologies. Currently he is Messaging Security Manager at Sunbelt Software, a security company. He is also the CTO of RADSense Software, a software consulting company. He has expertise in Microsoft technologies such as .NET Framework, ASP.NET, AJAX, SQL Server, C#, C++, Ruby On Rails, Cloud computing (Amazon and Windows Azure),and he also blogs about cloud technologies here.