Development · Uncategorized

Steps to create SQL database at Azure

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure.

Login into your Azure account and move to portal.

  1. Move to left side pane of portal and click on SQL databases.

1

2. Currently no database is available so we click on create a SQL database link. A new window will pop up like this –

2

Fill the required details in the create database window as Name of the database, collation of the database etc. I kept the rest of the details as default only you can change the settings as per your requirements.

3. Also select the option ‘New SQL database server’ option to create a new database server in SERVER point. Click on Arrow to further proceed to fill new database server details.

3

Fill the details Login name and Password to login into the server. Also, select your region and click on correct sign to complete this window.

4. In the SQL database pane we can see the new entry of the sql database that we created.

4

5. We can also check the server details from the Servers tab.

5

6. After creating the database, we can also get the option to export the database.

6

7. Click on Export link to export the database. A new window of Export Database gets opened.

7

Specify the filename by what name you want to export the database with extension .bacpac.

8. Now, choose the option to create the new storage account. Again, a new window gets opened of Create Storage Account. Fill the required details as URL, new container name and click on OK sign.

8

Once the database gets created we get the option of opening the database in Visual studio.

9. Click on Open In Visual Studio option. You also get the prompt to add the IP address in the firewall setting, allow that and proceed further.

9

10. After creating firewall rule allowing connection from your IP address, click Open.

11

12

After performing all the above steps, a new azure sql database is ready.

Hope you like this post.

Advertisements

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