SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Azure features limitation

SQL Server Azure, fully relational cloud database solution, is new possibility of the database administration and maintenance. I'm not going in deep to explain what about SQL Server Azure, the location where you can introduce and learn more is here & here.

In this post you will see the SQL Server Azure features limitations, including also some features from SQL Server 2005:

SQL Server 2008 features that are not supported by SQL Azure are:

  • Data Auditing
  • Data Compression
  • FileStream Data
  • Integrated Full-Text Search
  • Resource Governor
  • Spatial Data
  • SQL Server Replication
  • Transparent Data Encryption
  • etc etc...

SQL Server 2005 features that are not supported by SQL Azure are:

  • CLR
  • Database Mirroring
  • Table Partition
  • XML Indexing
  • etc.

Other SQL Server features that are not supported by SQL Azure are:

  • Backup and Restore
  • Replication
  • Ex Store Procedures
  • SQL Agent
  • SQL Profiler

For complete list and more details check here.

As you can see many of the features are not supported till today, but in the near future I think that they will be integrated and all of these things will be able to use same way as in SQL Server.

Stay Tuned!

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...


Posted by Jason Brimhall on 13 May 2010

Thanks for sharing.

Posted by Dukagjin Maloku on 13 May 2010

You're welcome!

Posted by Anonymous on 14 May 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, SQL Server Azure features limitation - Dukagjin Maloku - Dugi'SQL         [sqlservercentral.com]        on Topsy.com

Leave a Comment

Please register or log in to leave a comment.