Migrating Databases from SQL Server 2008 to SqlAzure

Posted by kaleidoscope on Geeks with Blogs See other posts from Geeks with Blogs or by kaleidoscope
Published on Mon, 22 Mar 2010 03:57:07 GMT Indexed on 2010/03/22 5:11 UTC
Read the original article Hit count: 493

Filed under:

Connect SQL Azure through SSMS. (It will get connected, only if you have port 1433 open.)

Create required databases on SQL Azure.

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

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

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

Anish

© Geeks with Blogs or respective owner