SQL Azure - Export Scripts Using Azure Management Portal


Introduction:


In this article we are going to see how to do an Export Database scripts available in SQL Azure Management Portal.

Overview:


We have seen in our earlier articles how to manage a database by creating tables, views and stored procedures directly in the Azure portal, now we are going to see the options available to Export an existing available script available on the Azure portal and use it across multiple environments.
In a traditional SQL Server locally we will create all the scripts and run the required scripts on the server based on the needs; in a similar manner we can create scripts on the SQL Azure portal and export it to any format as and when required to be executed in multiple environments. Let us see the procedure for doing an export using the Azure portal step by step.

Steps:


Log in to the Azure portal using the Azurelink. You will see the screen look similar to below.
http://www.microsoft.com/windowsazure/
image
Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the Management Portal and you will see the screen as shown in the screen below:
screenshot_02
Now we can see the Database Menu at the bottom left;, click on that to go to the Database Subscription window as shown in the screen below:
image
Clicking on the subscription name will provide the complete details of the server created and the new database created as shown in the screen below:
image
Assure we have created a database. (Check for my earlier article on how to create a database in SQL Azure.) Now go to the Manage portal by clicking on the Manage button on the top menu as shown in the screen below:
image_thumb[1]
Now we are prompted to enter the credentials to login to the server as shown in the screen below. Doing this is something like when we enter SQL Server Management Studio we will be asked to enter the login credentials.
image_thumb[2]
Once we have entered valid credentials our page will look like the following with the new SQL Azure Management Portal:
image
Assuming we have created the scripts on our own in the Azure portal itself and we want to export that file to save it locally and use it across our databases, our script generated file will look like below:
image
When we are done with the script and we are ready to export it now click on the Save button at the top left corner; it will then prompt to save the scripts in a file as shown in the screen below:
image
Clicking on "Save" will export all the scripts to the local machine and we can use it as needed to deploy in any machine to test or to stage.
Script file will look like below with the scripts
image

Conclusion:


So in this article we have seen how to do an export script using the SQL Azure Management Portal.