The usage of Azure SQL Database has increased many fold in the present times. Similarly, Azure blob containers are also widely used as a storage for storing both structured and unstructured data in the cloud based projects.

One of the most common scenarios we come across is the ability of transferring data to and from Azure blob containers to Azure SQL Database. This article gives a good overview on how this can be done

The article provides step by step approach for doing the data transfer and includes the following stages

Creating master key encryption by password

Creating database scoped credential

Creating external data source

Bulk Insert from Azure Blob Container

For anyone trying to implement similar scenario, this article will help them in getting started quickly