SIGN UP MEMBER LOGIN:    
ARTICLE

SQL Azure - Export Scripts Using Azure Management Portal

Posted by Karthikeyan Anbarasan Articles | Cloud Computing June 16, 2011
In this article we are going to see how to do an Export Database script available in SQL Azure Management Portal.
Reader Level:

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.

Login to add your contents and source code to this article
share this article :
post comment
 
Nevron Gauge for SharePoint
Become a Sponsor
PREMIUM SPONSORS
  • Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
    ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications. Visit DynamicPDF here
Team Foundation Server Hosting
Become a Sponsor