Creating your SQL Azure Database

Posted: December 3, 2011 in Windows Azure
Tags: , ,

I may like the windows azure storage more than the SQL Azure because it is cheaper and more scalable but I think the main advantage of SQL Azure is the relational database. Well it is a structured storage like the normal SQL Server. In this post we will create a database online using the Windows Azure portal.

First of all go to http://www.microsoft.com/windowsazure/ and click on sign in to the management portal, enter your email and password o login into your account.

Down at the right most you will find the Database icon just click on it

If you don’t have a server created already on your account you have to create one to do so, in the middle you will 3 things you can do:

  1. Create a new windows azure subscription
  2. Create a new SQL Azure Server
  3. Create a new SQL Azure Database

We will go for the second one “Create a new SQL Azure Server”

Follow the instructions that appear first of all define the place where do you want your database to be placed. In other words, there are 6 azure datacenters worldwide, so for developers you have to decide which one of these datacenters is the best of you depending on its location(the nearest one for your target people).

After this click on next, another window will appear for the administration of the server you have to define the administrator name and password.

The last step is:

you have to set rules for the firewall for those who can access your database with fixed IP addresses.

Finally you have your server created.

If you click on your server created at the right most you will see all your subscription information and if any database was created.

Now let’s move for the next step, is creating your database. At the top most you will find all what you can do to, from creating a new database, dropping the database and so on…

Now we will press on Create Database “The Blue one”.

You have to enter the database now, the edition and its size.

Now you have your Database created, you can see it, check its status and get all the information required if you click on it.

After you click on it you will find at the top most what you can do on the portal for your database created.

In this example we will manage the database, so click on manage at the top most like in the figure.

You will find yourself navigated to another web page in which it asks you for a user and a password

After entering the username and password, you will see the following page where you can create tables and do what you want online on the portal. Now click on “New Table” at the top most like in the following figure

Now you can add columns as much as you need and set their values, define which one is the primary key and so on…

Advertisements
Comments
  1. Ismail Habib says:

    Great article
    simple consistant and clear

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