Feed data to Azure SQL(PaaS) from Azure Storage blob RRS feed

  • Question

  • Hi 

    I want to feed  (import)  data to Azure SQL(Paas) from blob storage. I am wondering what are the best possible ways which do not require on-premise resources and economical as well ?

    1. If use mgmt studio then it require a virtual PC in Azure cloud or on-premise machine ? If I spin up VM in cloud just for this purpose then I have to pay for that VM every month.
    2. If I use my on-premise machine with SQL mgmt studio then there is a trouble re Biz firewall which will stop making connection with Azure SQL server , also dependency on that machine.

    Is there azure cloud based solution whereby we can instruct Azure SQL (PaaS) to get data from blob storage ?


    Thursday, January 19, 2017 11:35 PM


All replies