Exporting The SQL Data From Azure Cloud

Introduction

 
In the real world, many schools and colleges store student biodata, mark lists, attendance and activity data`in SQL databases. These organizations use some software tools for exporting the data. In emergency situations, sometimes this software tool doesn't work properly, so how to export the student data from the database? Azure gives an export option in our cloud portal.
 
Azure can provide three types of export options in our portal:
  • Json
  • Csv
  • Xml
By reading this article, you will learn about how to export queried SQL data from the Azure cloud.
 
Prerequisites for Creating SQL Server
  1. Azure cloud account
  2. Edge (or) other browsers
  3. Stable Internet Connection
  4. Minimum knowledge in Database
  5. SQL server & Database running in Azure
Refer to my previous articles:
Step 1
 
Login to Azure portal.
 
Step 2
 
Go to your database Dashboard and then open your query editor and execute the below queries to insert some data and retrieve all data from the database table.
 
Refer to my previous article, where I explained how to perform CRUD operations in Azure.
Exporting The SQL Data From Azure Cloud
 

Exporting as .Json file

 
After retrieval of your data, three export options are available at the top of the query editor. First, we will export our data in “Json” format.
 
Click “Export data as .json” download button, your json file can be downloaded by your browser .
 
Exporting The SQL Data From Azure Cloud
 
After downloading, open the downloaded .Json file. I opened this file using Visual Studio code, if you want click the following link to download Visual Studio code.
 
Exporting The SQL Data From Azure Cloud
 

Exporting as .Csv file

 
Click “Export data as .csv” download button, your csv file can be downloaded by your browser.
 
Exporting The SQL Data From Azure Cloud
 
After downloading, open the downloaded .csv file. I opened the .csv using MS Excel.
 
Exporting The SQL Data From Azure Cloud 
 

Exporting as .xml file

 
Click “Export data as .xml” download button, your xml file can be downloaded by your browser.
 
Exporting The SQL Data From Azure Cloud 
 
After downloading, open the downloaded .xml file. I opened the .xml using Internet Explorer.
 
Exporting The SQL Data From Azure Cloud 
 

Summary

 
Finally, we exported the SQL data in three types of file formats in the Azure portal.