SalesBuy
1-855-856-7678
Technical SupportSupport
SQL Server Feature Limitations (Windows Azure SQL Database)
Microsoft Windows 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 Windows Azure SQL Database and the SQL Server product. This topic lists some of the features from SQL Server 2008, SQL Server 2005, and earlier versions of SQL Server that are not supported by Windows Azure SQL Database.
For more information about Windows Azure SQL Database Transact-SQL support, see Transact-SQL Support (Windows Azure SQL Database). For more information about the differences between Windows Azure SQL Database and SQL Server in general, see Windows Azure SQL Database Overview.
SQL Server 2008 R2 Features Not Supported by SQL Database
The following features that were new to SQL Server 2008 R2 are not supported by Windows Azure SQL Database:
-
SQL Server Utility
-
SQL Server PowerShell Provider. PowerShell scripts can be run on an on-premise computer, however, and connect to Windows Azure SQL Database using supported objects (such as System Management Objects or Data-tier Applications Framework).
-
Master Data Services
SQL Server 2008 Features Not Supported by SQL Database
The following features that were new to SQL Server 2008 are not supported by Windows Azure SQL Database:
-
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
-
FILESTREAM Data
-
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
SQL Server 2005 Features Not Supported by SQL Database
The following features that were new to SQL Server 2005 are not supported by Windows Azure SQL Database:
-
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 Windows Azure SQL Database.
Other SQL Server Features Not Supported by SQL Database
The following features from earlier versions of SQL Server are not supported by Windows Azure SQL Database:
-
Backup and Restore
-
Replication
-
Extended Stored Procedures
-
SQL Server Agent/Jobs
See Also
