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:
By reading this article, you will learn about how to export queried SQL data from the Azure cloud.
Prerequisites for Creating SQL Server
-
Azure cloud account
-
Edge (or) other browsers
-
Stable Internet Connection
-
Minimum knowledge in Database
-
SQL server & Database running in Azure
Refer to my previous articles:
Step 1
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 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 .
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 as .Csv file
Click “Export data as .csv” download button, your csv file can be downloaded by your browser.
After downloading, open the downloaded .csv file. I opened the .csv using MS Excel.
Exporting as .xml file
Click “Export data as .xml” download button, your xml file can be downloaded by your browser.
After downloading, open the downloaded .xml file. I opened the .xml using Internet Explorer.
Summary
Finally, we exported the SQL data in three types of file formats in the Azure portal.