Generate Database Script from SQL Server for SQL Azure

Hello,

Today I am going to guide you about how to create database script in SQL Server 2008 above to simply let it work on SQL Azure. SQL Azure implements different rules to work with the databases including Primary Key constraint is mandatory for every table. Before running the script on SQL Azure make sure you have created a Primary Key in each table of database. The Screenshots below will help you to create the SQL database script for SQL Azure.
The First step is to right-click on the database you want to make script of for SQL Azure.

Secondly, Going onto tasks and click Generate Scripts

Generate Scripts will launch the Generate and publish scripts window. Press next and then again next. After that provide the location where to generate script and click on “Advance” button. Scroll to the property “script for the database engine type” and select SQL Azure from there, as shown below

Press Ok and press next after that and again next, then finish. The script will be generated for SQL Azure which you directly paste in the SQL Azure new query window under a Database you already have created on Windows Azure.

For more queries regarding Windows Azure, SQL Azure , feel free to contact at addresses below

Email: jkhan@programmer.net

Skype: jibrankhan1990