This topic describes the features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions.

Basic features

Category Feature RDS Cluster Edition RDS High-availability Edition RDS Basic Edition

SQL Server 2017 EE

SQL Server 2019 SE

SQL Server 2017 SE

SQL Server 2016 SE and 2016 EE

SQL Server 2012 SE and 2012 EE

SQL Server 2008 R2

SQL Server 2016 Web

SQL Server 2012 Web

SQL Server 2012 EE

Lifecycle Create an RDS instance Supported Supported Supported Supported
Restart an RDS instance
Enable auto-renewal for an RDS instance
Change the billing method of an RDS instance
Change the specifications of an RDS instance
Release an RDS instance
Create a temporary RDS instance Not supported Not supported Supported Supported
Upgrade the database engine version of an RDS instance Available soon Available soon Supported Available soon
Clone an RDS instance Supported Supported Not supported Supported
Create a read-only RDS instance Supported Not supported Not supported Not supported
Instance properties View a list of RDS instances Supported Supported Supported Supported
Query the details of an RDS instance
Change the description of an RDS instance
Set the maintenance window of an RDS instance
Manage tags
Migrate zones Not supported Not supported Supported Not supported
Database connection VPC endpoint Supported Supported Supported Supported
Public endpoint
Read/write splitting endpoint Not supported Not supported Not supported Not supported
Service availability Disaster recovery inside a zone Supported Supported Supported Supported
Cross-zone disaster recovery Supported Supported Supported Not supported
Cross-region disaster recovery Not supported Not supported Not supported Not supported
Disaster recovery drill
Backup and restoration Full backup Supported Supported Supported Supported
Incremental backup
Log backup
Customize backup policies for an RDS instance
Restore the data of an RDS instance from a backup set
Restore the data of an RDS instance to a point in time
Restore the data of an RDS instance from an external backup set Supported (full backup, differential backup, and log backup) Supported (full backup, differential backup, and log backup) Supported (full backup) Supported (full backup, differential backup, and log backup)
Restore the data of an RDS instance to a new RDS instance Supported Supported Not supported Available soon
Back up the partial data of an RDS instance Supported Supported Not supported Not supported
Restore the partial data of an RDS instance
Monitoring and alerting Monitor the resources of an RDS instance Supported Supported Supported Supported
Monitor the database engine and storage engine of an RDS instance
Customize monitoring policies
Aggregate monitoring items
Parameter management Parameter update Supported (T-SQL) Supported (T-SQL) Supported Supported (T-SQL)
Parameter template
Log management Error logs Supported (T-SQL) Supported (T-SQL) Supported Supported (T-SQL)
Operational logs

Data management features

Category Feature RDS Cluster Edition RDS High-availability Edition RDS Basic Edition

SQL Server 2017 EE

SQL Server 2017 SE

SQL Server 2016 SE and 2016 EE

SQL Server 2012 SE and 2012 EE

SQL Server 2008 R2

SQL Server 2016 Web

SQL Server 2012 Web

SQL Server 2012 EE

Data management User management Supported (T-SQL) Supported (T-SQL) Supported Supported (T-SQL)
Databases and table management Supported (T-SQL)
Data operation
Scheduled task
Data tunnel Homogeneous data migration Supported (DTS) Supported (DTS) Supported (DTS) Supported (DTS)
Heterogeneous data migration
Data synchronization
Data subscription Not supported Not supported Not supported Not supported
Database replication between RDS instances Supported Supported Not supported Supported
Data security IP address whitelist Supported Supported Supported Supported
Management and operation audit
Firewall Supported (IP address whitelist) Supported (IP address whitelist) Supported (IP address whitelist) Supported (IP address whitelist)
Database audit Supported Supported Supported Supported
Storage encryption Not supported Not supported Supported Not supported
Network encryption Supported Supported Supported Supported
Security group management Not supported Not supported Not supported Not supported
Performance optimization Expert service Supported Supported Supported Supported
Resource analysis Not supported Not supported Not supported Not supported
Engine analysis
Engine and code optimization

Features provided by Microsoft SQL Server

The following table describes the features that are provided by Microsoft SQL Server Web, Standard, and Enterprise editions.

Feature Web Edition Standard Edition Enterprise Edition
Specifications 16 CPU cores and 64 GB of capacity 24 CPU cores and 128 GB of capacity None
High availability (HA) Standalone Mirror HA Always On HA
Data compression Not supported Supported Supported
SQL Profiler
Column-based index
Table and index partitioning Supported by SQL Server 2016

Not supported by SQL Server 2012

Change Data Capture (CDC)
Online DDL Not supported
Parallel indexed operations
Parallelism adjustment of partitioned tables
TDE
Advanced R integration