Introduction
This article will cover the following things,
- Brief Concepts and Pre-requisites
- Implementation – Create SQL DB on Azure Platform
- Implementation – Use SQL Azure in VS 2017
Brief Concepts
What is SQL Azure?
- It’s a Microsoft’s cloud database service.
- It’s based on SQL Server database technology and built on Azure cloud computing platform.
- It enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.
- Its hosted, managed and provisioned in Microsoft data centers.
Pre-requisites
Read the following article to create an Azure account and for some basic information about Azure to get started.
Implementation – Create SQL DB on Azure Platform
Steps to be followed,
- Open Azure portal and go to SQL databases section and click on the Add symbol to add “SQL database”
- Fill the details of SQL, consisting of database name and use the existing resource group and create it.
- New DB has been added there, see the database section.
Implementation – Use SQL Azure in VS 2017
Steps to be followed,
- Open VS 2017 and refresh the SQL Databases and check the new database added there.
- Extract the relevant details from the SQL Azure like server-name, connection-string and all.
- Go to the VS and see the Data Connections and “add connection” and chose SQL server option.
- Add the new firewall rule and press OK
- Click on the database which has been recently created and click on “Open SQL Explorer” and connect using credentials
- After connect, connection will be shown in SQL server section under SQL server Object Explorer
- Go to the database and Add/Create a table Customer there with couple of fields ID and Name and click on the Update button.
- Click on the Update Database button to create it into the SQL Azure on the portal and wait for some time.
- See how the database has been updated by excuting the script on the database on Azure.
- See the SQL Server Object Explorer and see the new table created there.
Happy learning!
Join the conversation! Your thoughts help the community grow.