none
How to extract data from Azure SQL DB and write to anothe Azure SQL DB using U SQL Data Lake

    Question

  • Hi,

    I am new to Data Lake and U-SQL.

    Can any one suggest how to extract data from Azure SQL database using Data Lake by writing U-SQL Code and load the data into another Azure SQL database.

    It will be great if you can share couple of tips on data transformation using U-SQL.

    Best Regards,

    Sudhanshu

    Tuesday, April 18, 2017 8:45 AM

Answers

  • Dear Sudhanshu

    You can read data from Azure Data Lake by creating a Data Source and then either write a remote query or create an external table and query it. Some example scripts are here.

    You cannot write directly into another Azure SQL DB because of concerns about having a scaled out, non-transactional system writing data into a transacted table (this could lead to data corruption). So until we build a solution, please add your vote here and use Azure Data Factory to move the data (e.g., from a file in ADLS to the SQL DB).

    Cheers

    Michael


    Michael Rys

    Tuesday, April 18, 2017 9:51 PM
    Moderator