Geeks With Blogs

News kaleidoscope 1817, lit. "observer of beautiful forms," coined by its inventor, Sir David Brewster (1781-1868), from Gk. kalos "beautiful" + eidos "shape" (see -oid) + -scope, on model of telescope, etc. Figurative meaning "constantly changing pattern" is first attested 1819 in Lord Byron, whose publisher had sent him one.

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