locked
Copying multiple tables from On Premises SQL to Azure Blob RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Team,

    Using ADF, I wanted to move data from On Premises dataset having multiple tables to Azure Blob.  Can you please provide some help  or share some samples ?

    Thanks,

    Eshetu

    Wednesday, March 11, 2015 6:03 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You would follow this sample:

    http://azure.microsoft.com/en-us/documentation/articles/data-factory-use-onpremises-datasources/

    Essentially you use a Data Management Gateway service to live on premises to talk to SQL Server or to NTFS file system, to copy up to WASB blob storage.

    I don't know the bit about multiple tables in one JSON document, but I believe it can process a folder of files by giving the folder path instead of the full file name. You may have to use multiple data sets to copy multiple tables. 

    Thanks, Jason


    Didn't get enough help here? Submit a case with the Microsoft Customer Support teams for deeper investigation - Azure service support: https://manage.windowsazure.com/?getsupport=true For on Premise software support go here instead: http://support.microsoft.com/select/default.aspx?target=assistance

    Thursday, March 19, 2015 2:46 AM