Windows Azure – SQL Azure Management Portal Introduction

From the previous articles we have seen:

  • Creating database using Management Portal web application
  • Creating table through code
  • Using Management Studio desktop application

In this article we are going to discuss how to connect and create database using the online Management Portal application.

Advantage

One of the advantages of using it would be an extra tool that will be available on machines without SQL Server Management Studio installed.

SQL Azure Management Portal

For invoking the tool there are 2 ways.

Sign in to your management portal and click on the Manage button from the database view.

clip_image002

Or

Paste the url of your database in a browser address box. You can get the fully qualified url from the database server list as shown below.

clip_image004

In the above case the url would be http://abcd.database.windows.net

SQL Azure Management Portal Application

This is another silverlight application. The application will be prompting with the username and password. You need to enter your SQL Server username and password.

clip_image006

Enter your username and password and click the Log on button. (The database name is optional and we can choose later)


The Main Window

After login, you will be getting the following screen.

clip_image008

Creating new Database

We can create a new database using the Create button from the main window.

clip_image010

On clicking the button, within a short time you will be prompted with the following screen. You can enter the database details in it.

clip_image012

Use the Submit button and you will be ready with the database as shown below.

clip_image014

Summary

In this article we have seen how to connect and create database using the SQL Azure Management Portal. This tool provides an alternative way to the SQL Server Management Studio desktop application.

Leave a Reply

Your email address will not be published. Required fields are marked *