locked
Migrating Azure table storage content to On prem SQl database RRS feed

  • Question

  • hi 

    is it possible to import azure table storage data to On prem Sql database ?

    Wednesday, April 15, 2015 7:25 PM

Answers

  • Use Azure Data Factory - Define pipeline to move or copy data from Table storage to On-Premise SQL database.

    Actually we did use ADF to push the data from SQL to table storage which is other way of your ask. However i believe ADF supports this too.

    http://azure.microsoft.com/en-us/documentation/services/data-factory/


    Jagadeesh

    Thursday, April 16, 2015 7:35 AM

All replies

  • Hi

    You cannot do it directly from SQL or Azure Storage Explorer.

    But you can have a little application that extracts your table storage data into some CSV file like this:

    http://blogs.msdn.com/b/jmstall/archive/2012/08/03/converting-between-azure-tables-and-csv.aspx

    And then import the CSV file that you generate into your on-prem sql database

    Regards

    Aram


    Aram Koukia

    Wednesday, April 15, 2015 9:01 PM
  • But i think if data is in huge like millions of records excel sheet approach doesnt work since it has rows limitation right ?

    Thanks,

    Arun

    Wednesday, April 15, 2015 9:47 PM
  • Hi

    That's right, if there are lots of records, then I suggest you have to have an application to read the data and then insert them into the on-prem sql box as it reads them from the storage...


    Aram Koukia | Blog: koukia.ca | Twitter: @aramkoukia

    Wednesday, April 15, 2015 10:15 PM
  • Use Azure Data Factory - Define pipeline to move or copy data from Table storage to On-Premise SQL database.

    Actually we did use ADF to push the data from SQL to table storage which is other way of your ask. However i believe ADF supports this too.

    http://azure.microsoft.com/en-us/documentation/services/data-factory/


    Jagadeesh

    Thursday, April 16, 2015 7:35 AM