Generate script to Create SQL Azure database

Generally when you want to host your database on live server , you will prefer to generate script and run on live database server and it will create copy of your database on live.

In case of SQL Azure some script parameters are not allowed which will be generated with regulate "generate script" methods, you need to concern about following things please see the step below..

You required SQL Server -R2 for this procedure

1) Select Database > Task > Generate script 

 

2. Next > Choose object
3. Next > Choose srore option
4. Important step: click on Advance button and changes some property as per shown in below fig.
   

And it's done , you can run this script in Sql Azure and execute it , you just need to use SQL server 2008 R2 client for this.

Cheers.