Azure

Exporting The SQL Information From Azure Cloud

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

  1. Azure cloud account

  2. Edge (or) different browsers

  3. Secure Web Connection

  4. Minimal data in Database

  5. 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 .

 

Exporting The SQL Data From Azure Cloud

 

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 The SQL Data From Azure Cloud

 

Exporting as .Csv file

 

Click on “Export information as .csv” obtain button, your csv file might be downloaded by your browser.

 

Exporting The SQL Data From Azure Cloud

 

After downloading, open the downloaded .csv file. I opened the .csv utilizing MS Excel.

 

Exporting The SQL Data From Azure Cloud 

 

Exporting as .xml file

 

Click on “Export information as .xml” obtain button, your xml file might be downloaded by your browser.

 

Exporting The SQL Data From Azure Cloud 

 

After downloading, open the downloaded .xml file. I opened the .xml utilizing Web Explorer.

 

Exporting The SQL Data From Azure Cloud 

 

Abstract

 

Lastly, we exported the SQL information in three varieties of file codecs within the Azure portal.

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button