Move on premises SQL data to Azure Data lake without using ADF


  • hi Guys,

    How do I move on premises SQL data to Azure Data lake store without using Azure data factory?




    Wednesday, June 15, 2016 12:57 AM

All replies

  • Hi Navin,

    You could do it in multiple ways:

    1. Dump out data into file using tools like BCP. Copy files to Azure Data Lake store, using Powershell, custom app etc.

    2. Use sqoop running onprem to copy data to WASB. Copy data from WASB to Azure Data Lake Store using tool of choice (Azure Data Factory, etc.).

    Do these options work for you?

    Sachin Sheth
    Program Manager, Azure Data Lake.

    Wednesday, June 15, 2016 1:11 AM