Update to my post on SQL Azure Migration Wizard

Earlier I had written on migrating your Northwind database from SQL Server to SQL Azure.  In that, I had mentioned that the SQL Azure Migration Wizard supports migrating the schema and doesn’t do the data migration which has to be done manually.

Meanwhile, George Huey has published a recent version on the SQL Azure Migration Wizard at CodePlex which also does data migration.  What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along with data into your SQL Azure Database.  That’s one hell of work done in a single step, I would say.

What’s more, the recent version also supports the following options

SQL Server to SQL Azure (existing)

SQL Azure to SQL Server

SQL Azure to SQL Azure (multiple accounts)

You can download the latest version from http://sqlazuremw.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=32334

Cheers !!!

Print | posted on Wednesday, December 23, 2009 2:04 AM

Comments on this post

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
thanks for information. greetings from Turkey
Left by muzik dinle on Dec 26, 2009 1:59 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
http://taylormade.lgnprosperity.com/
LGN has been in business since August of 2007. We are excited about creating another way for individuals to generate massive income from the comfort or their home by introducing the LGN Prosperity 2x2 Matrix System!
Left by ads on Jan 08, 2010 2:04 AM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
Thank you for the download link you provided...
Left by bingo tips on Mar 26, 2010 3:29 AM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...

I search them on the Internet,they are so
beautiful.
cheap christian louboutin shoes
Left by summer on Mar 29, 2010 5:16 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
It is by far one of the funniest sites that I have come across.
Left by manolo blahnik store on Apr 06, 2010 1:30 AM

# # re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along with data into your SQL Azure Database.
Left by Goji marjat on May 02, 2010 4:06 AM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
Thanks for the tips, you'd think they'd be able to do it automatically & not have to do it manually.
Left by concession trucks on May 17, 2010 4:37 AM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
Thanx Meksika biberi güzel bir hap
Left by meksika biberi zayıflama hapı on May 31, 2010 11:00 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
thanks for the download link
Left by Lifecell Wrinkle Cream on Jun 05, 2010 9:58 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
Cheers man. Good tips
Left by Control Premature Ejaculation on Jun 08, 2010 1:52 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
Thanks for the article and the download link.
Left by U Shaped Desk on Oct 28, 2010 9:32 PM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
The task of moving to the cloud before this tool was daunting. However, with this bit of code, we were not only able to migrate the scheme but the data and it allowed a quick and easy upgrade path.
Left by Concession Trailer on Dec 16, 2010 6:11 AM

# re: Update to my post on SQL Azure Migration Wizard

Requesting Gravatar...
wow.. unbelievable
Left by jaw pain on Mar 04, 2011 1:44 AM

Your comment:

 (will show your gravatar)