locked
Pull Azure storage data to local SQL RRS feed

  • 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

    Friday, November 30, 2012 9:18 PM

Answers

  • 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

    Tuesday, December 4, 2012 1:58 PM

All replies

  • 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 msdnmg@microsoft.com Microsoft One Code Framework

    • Proposed as answer by _mmjj_jjyy Monday, December 10, 2012 4:54 AM
    Sunday, December 2, 2012 8:19 AM
  • 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


    • Proposed as answer by _mmjj_jjyy Monday, December 10, 2012 4:54 AM
    • Edited by Adam Hoffman Sunday, January 6, 2013 4:37 AM
    Monday, December 3, 2012 4:42 PM
  • 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

    Monday, December 3, 2012 8:28 PM
  • 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

    Tuesday, December 4, 2012 1:58 PM
  • 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

    Saturday, December 8, 2012 9:07 AM
  • Hi,

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


    Best Regards,
    Carlos Sardo

    Sunday, December 9, 2012 11:05 PM