Pull Azure storage data to local SQL

Question

Hi All,

Is there any tools or a way to pull my Azure storage account data to my local database? Any help would be helpful

- Thanks

---

-Bharath

Answer 1

Hi,

If you want to export a database from Windows Azure SQL Database to an on-premise SQL Server, first export the database to a BACPAC file, transfer the BACPAC file to your local server (computer), and then import the BACPAC file to your on-premise SQL Server.

http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx 

http://msdn.microsoft.com/en-us/library/windowsazure/jj650016.aspx 

Best Regards

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 2

Are you trying to get Windows Azure SQL Database data pulled down or are you trying to get Windows Azure Table Storage data pulled down?

From the sound of your question, I'm guessing that you're trying to get Table Storage data, not SQL data.  Is that correct?

-adam

My Windows Azure Blog - http://stratospher.es

My Twittererer  - http://www.twitter.com/stratospher_es

Answer 3

yes Adam, ur right. I want to pull my Azure table storage data to my local database. If it is possible, can we also pull table storage data from multiple accounts to a single local database?

---

-Bharath

Answer 4

Hi,

You could use Azure Storage Explorer and export your table contents to CSV or XML and import it to your SQL Database using the SQL Server Management Studio Import Data wizard.

Hope this helps!

---

Best Regards,
Carlos Sardo

Answer 5

Thanks for the information Carlos, but is there a way to automate it? (like configuring SQL server to the application so that it copies the data automatically). I am using Azure storage extractor which is not much helpful. 

Thanks!

---

-Bharath

Answer 6

Hi,

No, I don't know any tool that could help you automate this process.

---

Best Regards,
Carlos Sardo