How to export data from SQL server to a storage container

Question

Hi All.

I will like the output of a SQL query to be stored in a storage container in Azure, was wondering what is the best/secure way of doing this in an automated fashion. This can be one output file for each day, the output is a json type.

Ideas welcome please.

Thanks in advance.

Answer 1

@MrFlinstone You can easily achieve this using a Logic App.

Posting a screenshot from one of my projects.
This runs at a specified schedule, copies over data from an Azure SQL database to a file on blob.

Please try and let us know if you need any further help.

--
If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.

Answer 2

You can also think of using Azure data factory. Create a pipeline, use Copy activity task and configure source Azure SQL and target Azure storage. Schedule this pipeline to run daily.

Reference: tutorial-incremental-copy-portal

----------

If the response helped, do "Accept Answer" and upvote it Vaibhav