This topic describes the functions supported by different versions and editions of SQL Server.

Basic functions

Module Function High-availability editions Basic editions

2016 Standard/Enterprise

2012 Standard/Enterprise

2008 R2 Enterprise

2016 Web

2012 Web

2012 Enterprise

Life cycle Create an instance Supported Supported Supported
Restart an instance
Automatic renewal
Change the billing method
Change specifications
Release an instance
Create a temporary instance Not supported Supported Supported
Upgrade the engine version Coming soon Supported Coming soon
Clone an instance Supported Not supported Supported
Create a read-only instance Not supported Not supported Not supported
Instance properties View a list of instances Supported Supported Supported
View instance details
Edit instance description
Set the maintenance time period
Manage instance labels
Migrate to another zone Not supported Supported Not supported
Database connection VPC address Supported Supported Supported
Public network address
Read/write splitting address Not supported Not supported Not supported
Service availability Disaster recovery in a zone Supported Supported Supported
Cross-zone disaster recovery Supported Supported Not supported
Cross-region disaster recovery Not supported Not supported Not supported
Disaster recovery drill
Backup and restore Full backup Supported Supported Supported
Incremental backup
Log backup
Customize backup policies
Restore from a backup set
Restore to time
Restore from external backup files Supported (full backup, differential backup, or log backup) Supported (full backup) Supported (full backup, differential backup, or log backup)
Restore to a clone instance Supported Not supported Coming soon
Partial backup Supported Not supported Not supported
Partial restore
Monitoring and alarms Resource monitoring Supported Supported Supported
Engine monitoring
Customize monitoring policies
Aggregate monitoring items
Parameter management Parameter update Supported (T-SQL) Supported Supported (T-SQL)
Parameter template
Log management Error logs Supported (T-SQL) Supported Supported (T-SQL)
Running logs

Data management functions

Module Function High-availability editions Basic editions

2016 Standard/Enterprise

2012 Standard/Enterprise

2008 R2 Enterprise

2016 Web

2012 Web

2012 Enterprise

Data management User management Supported (T-SQL) Supported Supported (T-SQL)
Databases and table management Supported (T-SQL)
Table operations
Task scheduling
Data tunnel Homogeneous data migration Supported (DTS) Supported (DTS) Supported (DTS)
Heterogeneous data migration
Data synchronization
Data subscription Not supported Not supported Not supported
Database replication between instances Supported Not supported Supported
Data security IP address whitelist Supported Supported Supported
Management and operation audit
Firewall Supported (IP address whitelist) Supported (IP address whitelist) Supported (IP address whitelist)
Database audit Coming soon Supported Coming soon
Storage encryption Not supported Supported Not supported
Network encryption Not supported Supported Not supported
Security group management Not supported Not supported Not supported
Performance optimization Professional service Supported Supported Supported
Resource analysis Not supported Not supported Not supported
Engine analysis
Engine/code optimization

Functions supported by official editions

The following table describes the functions supported by SQL Server Web, Standard, and Enterprise editions.

Function Web Edition Standard Edition Enterprise Edition
Specifications 16-core 64 GB 24-core 128 GB None
High availability Single host Mirror HA Always On availability
Data compression Not supported Supported Supported
SQL Profiler
Column-based index
Table/index partitioning Supported by SQL Server 2016 but not by SQL Server 2012
CDC
Online DDL Not supported
Parallel queries
Adjust parallelism of partitioned tables
TDE
Advanced R integration