Geeks With Blogs
Kaleidoscope Everything under the sun, ending in .Net
  1. Connect SQL Azure through SSMS. (It will get connected, only if you have port 1433 open.)

clip_image001

  1. Create required databases on SQL Azure.

clip_image002

  1. Create and execute schema scripts for databases.(Make sure you have written scripts which are 100% compatible with SQL Azure. Tool called SQL Azure migration tool by CodePlex helps with doing this.)

clip_image003

  1. Create and execute insert scripts for databases. (One can use SSMS for generating insert scripts.)

clip_image004

For further details refer to the Windows Azure Platform Kit Nov 2009.

 

Anish

Technorati Tags:
Posted on Sunday, March 21, 2010 4:57 PM | Back to top


Comments on this post: Migrating Databases from SQL Server 2008 to SqlAzure

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © kaleidoscope | Powered by: GeeksWithBlogs.net