Home > Azure SQL, Learning, SQL 2012, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSC > SQL Server features that are not supported by Azure SQL Database

SQL Server features that are not supported by Azure SQL Database

SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that are not supported and here are some of them (short info):

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

  • SQL Server Utility
  • Master Data Services

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

  • Change Data Capture
  • Data Auditing
  • Data Compression
  • Extended Events
  • Filestream Data
  • Integrated Full-Text Search
  • Policy-Base Management
  • Resource Governor
  • SQL Server Replication
  • Transparent Data Encryption

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

  • Common Language Runtime (CLR and CLR User-Defined Types)
  • Database Mirroring
  • Service Broker
  • Table Partitioning
  • XML Indexing

Other features that are not supported as well:

  • Backup and Restore
  • Replication
  • Extended Store Procedure
  • SQL Server Agent

For more information you can check here.

About these ads
  1. No comments yet.
  1. No trackbacks yet.

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

Follow

Get every new post delivered to your Inbox.

Join 815 other followers

%d bloggers like this: