Answered by:
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 ?
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
- Marked as answer by Michael CurdMicrosoft employee Monday, April 20, 2015 6:30 PM
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
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
- Marked as answer by Michael CurdMicrosoft employee Monday, April 20, 2015 6:30 PM
Thursday, April 16, 2015 7:35 AM