Export (0) Print
Expand All

SQL Server Feature Limitations (Azure SQL Database)

Updated: February 21, 2014

Microsoft Azure SQL Database is very similar to SQL Server in terms of Transact-SQL support and the tabular data stream (TDS) protocol that it uses to communicate with your database client. In terms of feature support, there are some differences between Microsoft Azure SQL Database and the SQL Server product. This topic lists some of the features from SQL Server that are not supported by Microsoft Azure SQL Database.

For more information about Microsoft Azure SQL Database Transact-SQL support, see Azure SQL Database Transact-SQL Support. For more information about the differences between Microsoft Azure SQL Database and SQL Server in general, see SQL Database Overview.

The following features that are not supported by Microsoft Azure SQL Database:

  • SQL Server Utility

  • SQL Server PowerShell Provider. PowerShell scripts can be run on an on-premise computer, however, and connect to Microsoft Azure SQL Database using supported objects (such as System Management Objects or Data-tier Applications Framework).

  • Master Data Services

  • Change Data Capture

  • Data Auditing

  • Data Compression

  • Extended Events

  • Extension of spatial types and methods through Common Language Runtime (CLR)

  • External Key Management / Extensible Key Management


  • Integrated Full-Text Search

  • Large User-Defined Aggregates (UDAs)

  • Large User-Defined Types (UDTs)

  • Performance Data Collection (Data Collector)

  • Policy-Based Management

  • Resource Governor

  • SQL Server Replication

  • Transparent Data Encryption

  • Common Language Runtime (CLR) and CLR User-Defined Types

  • Database Mirroring

  • Service Broker

  • Table Partitioning

  • Typed XML and XML indexing is not supported. The XML data type is supported by Microsoft Azure SQL Database.

  • Backup and Restore

  • Replication

  • Extended Stored Procedures

  • SQL Server Agent/Jobs

See Also

© 2014 Microsoft