Connect Azure SQL to azure storage table?

All replies

• 

  

  0

  Sign in to vote

  Sure, but not automatically. You'd have to write some kind of application or service for it.

   

   

  ---

  With regards,
  
  Patriek
  
  www.patriekvandorp.net

  ---

  If this reply is of help to you, please don't forget to mark it as an answer.

  • Proposed as answer by DamPee Monday, July 11, 2011 9:01 PM

  Monday, July 11, 2011 9:33 AM
• 

  

  0

  Sign in to vote

  Can I do it from Stored procedure?

  Connect from SP to Azure storage table like OLEDB

  SET @execQuery = ' Select * into ' + @tempTableName + ' from OPENROWSET(''SQLNCLI'',''Server=tcp:IPaddess;Database=XXX;Trusted_Connection=yes;'',''' + @sqlTempQuery + ''') AS a;'

  exec sp_executesql @execQuery

  Monday, July 11, 2011 10:44 PM
• 

  

  0

  Sign in to vote

  Hi valQC1,

  > Connect from SP to Azure storage table like OLEDB

  I am afraid we cannot connect to Azure storage table from Stored procedure. As far as I known, the ways to connect to Azure storage are Azure SDK and REST API.

  If you need further assistance, please feel free to let me know.

  Thanks.

  ---

  Wenchao Zeng
  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

  • Marked as answer by valQC1 Wednesday, July 13, 2011 12:09 AM

  Tuesday, July 12, 2011 10:12 AM