«
»

28 Oct

Difference between SQL and SQL Azure

Posted October 28, 2010 by algoguru in Uncategorized.

  1. Tables must have clustered index
  2. User will not have access to System Views and System Tables
  3. Database mirroring and Failover are not supported as it is supported by Azure platform itself
  4. At this point SSAS, SSRS, and Service Broker are not supported.
  5. There is no support for CLR integrated SQL Statements.
  6. Database backup & Restore are not possible.  You can use SSIS, SQL Azure migration wizard to do this.

For more details refer MSDN page

Leave a comment