locked
Export data to azure table RRS feed

  • Question

  • I want a SP that writte data in a Azure Table.

    In Sql sever, i can writte a clr sp, that use a wcf to conect with the tabla azure.

    In SqlAzure? how do it?

    Thanks

     

    Monday, August 8, 2011 11:12 AM

Answers

  • Hi Borin2,

    To access to Windows Azure Table Storage, we can use either REST API or Storage Client Library. However, since SQL Azure does not provide support for CLR Integration, I don’t think we can access Windows Azure Table Storage in SQL Azure. 


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Get or Request Code Sample from Microsoft
    If you have any feedback, please tell us.
    • Marked as answer by KJian_ Monday, August 29, 2011 6:54 AM
    Thursday, August 11, 2011 8:32 AM

All replies

  • Hi,

    In Azure you would have to create a worker role that reads from SQL Azure, then writes to an Azure Table. For the moment you cannot create stored procedures that access Azure Storage.

     


    Herve Roggero, MVP SQL Azure Co-Author: Pro SQL Azure http://www.herveroggero.com
    Monday, August 8, 2011 1:48 PM
  • Hi Borin,

    Please take a look at these articles

    http://blogs.msdn.com/b/jnak/archive/2008/10/28/walkthrough-simple-table-storage.aspx

    http://blogs.msdn.com/b/jnak/archive/2010/01/06/walkthrough-windows-azure-table-storage-nov-2009-and-later.aspx

    Hope this helps !!!


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
    Monday, August 8, 2011 2:36 PM
  • Well, it is no good for me.

    I need a Store procedure that write data in WA TABLE, beaucose i have a transaction i my precedure, and i need writte and error (if it would be)

     

    Monday, August 8, 2011 4:40 PM
  • Hi Borin2,

    To access to Windows Azure Table Storage, we can use either REST API or Storage Client Library. However, since SQL Azure does not provide support for CLR Integration, I don’t think we can access Windows Azure Table Storage in SQL Azure. 


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Get or Request Code Sample from Microsoft
    If you have any feedback, please tell us.
    • Marked as answer by KJian_ Monday, August 29, 2011 6:54 AM
    Thursday, August 11, 2011 8:32 AM
  • I don't think there's a way to do it currently inside SP.
    regards, wely
    Thursday, August 11, 2011 3:00 PM
  • How about having an SSIS package to read data from SQL Azure/SQL Server and write into Azure Table?
    Please mark it as answer by clicking on "Propose As Answer", if it helps. My Blog : http://dotnetizen.blogspot.com
    Thursday, August 11, 2011 8:10 PM