Azure SQL Database features

Azure SQL Database shares a common code base with SQL Server and, at the database level, supports most of the same features. The major feature differences between Azure SQL Database and SQL Server are at the instance level.

We continue to add features to Azure SQL Database. So we encourage you to visit our Service Updates webpage for Azure, and to use its filters:

SQL Server and SQL Database feature support

The following table lists the major features of SQL Server and provides information about whether each particular feature is supported and a link to more information about the feature. For Transact-SQL differences to consider when migrating an existing database solution, see Resolving Transact-SQL differences during migration to SQL Database.

SQL Server Feature Supported in Azure SQL Database
Always Encrypted Yes - see Cert store and Key vault
AlwaysOn Availability Groups No - see Failover groups and active geo-replication
Attach a database No
Application roles Yes
BACPAC file (export) Yes - see SQL Database export
BACPAC file (import) Yes - see SQL Database import
BACKUP command No - see Automated backups
Built-in functions Most - see individual functions
Change data capture No
Change tracking Yes
Collation statements Yes
Columnstore indexes Yes - Premium edition only
Common language runtime (CLR) No
Contained databases Yes
Contained users Yes
Control of flow language keywords Yes
Cross-database queries Partial - see Elastic queries
Cursors Yes
Data compression Yes
Database mail No
Database mirroring No
Database configuration settings Yes
Data Quality Services (DQS) No
Database snapshots No
Data types Yes
DBCC statements Most - see individual statements
DDL statements Most - see individual statements
DDL triggers Database only
Distributed transactions - MS DTC No - see Elastic transactions
DML statements Most - see individual statements
DML triggers
DMVs Some - see individual DMVs
Event notifications No - see Alerts
Expressions Yes
Extended events Some - see individual events
Extended stored procedures No
Files and file groups Primary file group only
Filestream No
Full-text search Third-party word breakers are not supported
Functions Most - see individual functions
Graph processing Yes
In-memory optimization Yes - Premium edition only
JSON data support Yes
Language elements Most - see individual elements
Linked servers No - see Elastic query
Log shipping No - see Failover groups and active geo-replication
Master Data Services (MDS) No
Minimal logging in bulk import No
Modifying system data No
Online index operations Supported - transaction size limited by service tier
Operators Most - see individual operators
Point in time database restore Yes - see SQL Database recovery
Polybase No
Policy-based management No
Predicates Most - see individual predicates
R Services Preview release; see What's new in machine learning
Resource governor No
RESTORE statements No
Restore database from backup From built-in backups only - see SQL Database recovery
Row Level Security Yes
Semantic search No
Sequence numbers Yes
Service Broker No
Server configuration settings No
Set statements Most - see individual statements
Spatial Yes
SQL Server Agent No - see Elastic jobs
SQL Server Analysis Services (SSAS) No - see Azure Analysis Services
SQL Server Auditing No - see SQL Database auditing
SQL Server Integration Services (SSIS) No - see Azure Data Factory
SQL Server PowerShell Yes
SQL Server Profiler No - see Extended events
SQL Server Replication Transactional and snapshot replication subscriber only
SQL Server Reporting Services (SSRS) No
Stored procedures Yes
System stored functions Some - see individual functions
System stored procedures Some - see individual stored procedures
System tables Some - see individual tables
System catalog views Some - see individual views
Table partitioning Yes - primary filegroup only
Temporary tables Local and database-scoped global temporary tables only
Temporal tables Yes
Variables Yes
Transparent data encryption (TDE) Yes
Windows Server Failover Clustering No - see Failover groups and active geo-replication
XML indexes Yes

Next steps