.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

SQL Azure - Export Scripts using Azure portal

Posted By:Karthikeyan Anbarasan       Posted Date: June 28, 2011    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

In this article we are going to see how to do an Export Database scripts available in SQL 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 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

Steps:

Log in to the Azure portal using the below link. You can 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 will 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. This is some like while we enter SQL Server Management Studio we will be asked to enter the login credentials

image_thumb[2]

Once we entered valid credentials our page will look like below with the new SQL Azure Management portal

image

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

image

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

image

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

image

Conclusion:

So in this article we have seen on how to do an export script using the SQL Azure management portal


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend