​

Earlier, I created a table in the cloud SQL database and imported CSV data. This time, conversely, export the table and extract it as a CSV file on your computer.

 

[Extract data from Azure SQL database]
 

I referred to the following site.

Azure SQL Database: Connect and query data using SQL Server Management Studio.

​

 

Source: https://docs.microsoft.com/ja-jp/azure/sql-database/sql-database-connect-query-ssms
 

​

<Flow of outline>

 

1. Log in to Azure Portal site
Get connection information required to connect to Azure SQL database.

2. Connect to a database

Open SQL Server Management Studio.
Start SQL Database Import and Export Wizard
Connect to a database

3. Select CSV file as conversion destination

Create an empty CSV file on your computer and specify it as the conversion destination.

4. Execute data query

Extract all data.

5. CSV data check

Check the work result data added to the CSV file on the PC.

 

December 8, 2017
 

​