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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s