Introduction
In the actual world, many colleges and faculties retailer scholar biodata, mark lists, attendance and exercise information`in SQL databases. These organizations use some software program instruments for exporting the info. In emergency conditions, typically this software program software does not work correctly, so export the scholar information from the database? Azure offers an export choice in our cloud portal.
Azure can present three varieties of export choices in our portal:
By studying this text, you’ll study export queried SQL information from the Azure cloud.
Stipulations for Creating SQL Server
-
Azure cloud account
-
Edge (or) different browsers
-
Secure Web Connection
-
Minimal data in Database
-
SQL server & Database working in Azure
Discuss with my earlier articles:
Step 1
Step 2
Go to your database Dashboard after which open your question editor and execute the beneath queries to insert some information and retrieve all information from the database desk.
Discuss with my earlier article, the place I defined carry out CRUD operations in Azure.
Exporting as .Json file
After retrieval of your information, three export choices can be found on the high of the question editor. First, we’ll export our information in “Json” format.
Click on “Export information as .json” obtain button, your json file might be downloaded by your browser .
After downloading, open the downloaded .Json file. I opened this file utilizing Visual Studio code, in order for you click on the next hyperlink to obtain Visual Studio code.
Exporting as .Csv file
Click on “Export information as .csv” obtain button, your csv file might be downloaded by your browser.
After downloading, open the downloaded .csv file. I opened the .csv utilizing MS Excel.
Exporting as .xml file
Click on “Export information as .xml” obtain button, your xml file might be downloaded by your browser.
After downloading, open the downloaded .xml file. I opened the .xml utilizing Web Explorer.
Abstract
Lastly, we exported the SQL information in three varieties of file codecs within the Azure portal.
