A look on Database [SQL Azure] option of new Windows Azure portal

Windows Azure Development portal has been moved to new Silverlight based portal. It has all new look and many new features.

SQL Azure can be explored by selecting Database option from the left panel.

clip_image001

New SQL Azure portal is having very nice Silverlight based user interactive UI and many more operations can be performed through the UI. There is new database manager and it allows us to perform operations at table and row level.

Now we can perform many more operations through Database option of new Windows azure portal.

1. Create a database

2. Create/ delete a table

3. Create/edit/delete rows of table.

4. Create/edit stored procedure

5. Create/edit views

6. Create / execute queries etc. . . .

Let us have a walkthrough on various operations we can perform on Database option of new Windows Azure portal.

To create new Database, select Data base server and from Database section, select Create option.

clip_image003

You will get the below popup, select subscription and server from drop down

clip_image004

Give name of the Database, select Edition and maximum size of the database.

clip_image006

Once database got created, select Manage option from top to open Data Base Manager.

clip_image008

Accept given term and conditions and click Ok.

clip_image009

After Ok, you will get popup asking password to connect to database. Provide password and click on Connect .

clip_image010

After successful connection , you will get a cube providing all the information about the database you connected.

clip_image011

You can perform all the database operations from the top ribbon. You have option to create new query, new table, new view, and new stored procedure

clip_image012

If we want to create new table, click on New Table option from ribbon. We are creating a table with name Blogger. We are giving there columns ID, Name and Technology. From drop down we can select data type for the columns .

clip_image014

Then click on save button at top,

clip_image015

You can navigate between Data Base and Table tab. You can create and delete column from here also. Once you click on save button, you can see table listed at left panel.

clip_image016

At top you can see you have option to navigate either design or data view of table. Click on Data tab to navigate to Data view.

Click on Row to add a Row in the table.

clip_image017

After adding two rows, you can see table as below. You can add and delete rows from top button also.

clip_image019

Now to execute query, select Data Base tab at top and execute query as below,

clip_image021

When you click Execute button at top, you will get output as below,

clip_image023

In this way , you can perform almost all the basic operations from new SQL Azure Data Base Manager.

About these ads

3 thoughts on “A look on Database [SQL Azure] option of new Windows Azure portal

  1. Pingback: Listing Firewall rules in SQL Azure « DEBUG MODE……

  2. Pingback: Monthly Report March 2011: Total Posts 15 « debug mode……

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s