Migrating Azure table storage content to On prem SQl database

Question

hi 

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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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