In this article we are going to see how to do an Export Database scripts available in SQL Azure management portal.
We have seen in our earlier articles on how to manage a database by creating tables, views, stored procedures directly in the azure portal, now we are going to see on the options available to Export an existing available scripts available on the Azure portal and use it across in different environments..
In a traditional SQL Server locally we will create all the scripts and run the required scripts on to the server-based on the needs, similar wise we can Create scripts on the SQL Azure portal and export it to any format as and when required to be executed in different environments. Let us see on the options how to do an export using the Azure portal step by step
Log in to the Azure portal using the below link. You can see the screen look similar to below
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
Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below
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
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
Now we are prompted to enter the credentials to login to the server as shown in the screen below. This is some like while we enter SQL Server Management Studio we will be asked to enter the login credentials
Once we entered valid credentials our page will look like below with the new SQL Azure Management portal
Assume 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. So our script generated file will look like below
Once we are done with the script and we are ready to export it now click on the Save button at the top left corner will prompt to save the scripts in a file as shown in the screen below
Clicking on save will export all the scripts to the local machine and we can use it as per our requirement to deploy in any machine to test or to stage.
Script file will look like below with the scripts
So in this article we have seen on how to do an export script using the SQL Azure management portal