All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

From the Ground to the Sky – SQL Azure Migration Wizard

From the Ground to the Sky – SQL Azure Migration Wizard

  • Comments 1
  • Likes

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 :)

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment