Many of you maybe playing around with your CTP invitations for SQL Azure and wondering how to get your current on premises databases into the cloud. Some options you have probably used:

  • Script out the database and modify these scripts quite a lot to recreate the objects in the cloud
  • Once you have got the structure, you have probably used SSIS or bcp to get the data into the cloud.

Now with the SQL Azure Migration Wizard, it 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.

This wizard can be downloaded from - http://sqlazuremw.codeplex.com/ 

Happy Flying to the Cloud :)