Floating FB popout byF5debug

SQL Azure – Export Scripts using Azure 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.

[more]

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/

clip_image002

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

clip_image004

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

clip_image006

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

clip_image008

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

clip_image009

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

clip_image010

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

clip_image011

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

clip_image012

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

clip_image013

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

clip_image014

Conclusion:

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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter