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 2019 EE SQL Server 2017 EE | SQL Server 2019 SE SQL Server 2017 SE SQL Server 2016 SE and SQL Server 2016 EE SQL Server 2012 SE and SQL Server 2012 EE | SQL Server 2008 R2 EE | SQL Server 2016 Web SQL Server 2012 Web SQL Server 2012 EE | ||
| Lifecycle | Instance creation | Supported | Supported | Supported | Supported |
| Instance restart | |||||
| Auto-renewal | |||||
| Billing method change | |||||
| Specifications change | |||||
| Instance release | |||||
| Temporary instance creation | Not supported | Not supported | Supported | Supported | |
| Upgrade of the database engine version | Supported | Supported | Supported | Supported | |
| Instance cloning | Supported | Supported | Not supported | Supported | |
| Read-only instance creation | Supported | Not supported | Not supported | Not supported | |
| Instance properties | Viewing of instances | Supported | Supported | Supported | Supported |
| Viewing of the instance details | |||||
| Description change | |||||
| Maintenance window configuration | |||||
| Tag management | |||||
| Zone management | Not supported | Not supported | Supported | Not supported | |
| Database connection | Virtual private cloud (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 | |
| Geo-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 | |||||
| Backup policy customization | |||||
| Restoration by backup file | |||||
| Restoration by point in time | |||||
| Restoration by user backup file | 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) | |
| Restoration by using a cloned instance | Supported | Supported | Not supported | Available soon | |
| Backup of partial data | Supported | Supported | Not supported | Not supported | |
| Restoration of of partial data | |||||
| Monitoring and alerting | Resource monitoring | Supported | Supported | Supported | Supported |
| Engine monitoring | |||||
| Monitoring policy customization | |||||
| Monitoring aggregation | |||||
| 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) |
| Run logs | |||||
Data management features
| Category | Feature | RDS Cluster Edition | RDS High-availability Edition | RDS Basic Edition | |
|---|---|---|---|---|---|
SQL Server 2019 EE SQL Server 2017 EE | SQL Server 2017 SE SQL Server 2016 SE and SQL Server 2016 EE SQL Server 2012 SE and SQL Server 2012 EE | SQL Server 2008 R2 EE | 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) |
| Database and table management | Supported (T-SQL) | ||||
| Data operation | |||||
| Scheduled task | |||||
| Data tunnel | Homogeneous data migration | Supported (DTS) | Supported (DTS) | Supported (DTS) | Supported (DTS) Note DTS is not supported by the SQL Server Web edition. |
| 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 Edition, Microsoft SQL Server SE, and Microsoft SQL Server EE.
| Feature | Microsoft SQL Server Web Edition | Microsoft SQL Server SE | Microsoft SQL Server EE |
|---|---|---|---|
| Specifications | 16 cores and 64 GB of capacity | 24 cores and 128 GB of capacity | None |
| High availability (HA) | Standalone | Mirror HA | Always On HA |
| Data compression | Not supported | Supported Note The CDC feature is supported for the Standard editions of SQL Server 2016 or later. | Supported |
| SQL Profiler | |||
| Change data capture (CDC) | |||
| Column-based index | |||
| Online DDL | Not supported | ||
| Parallel indexed operations | |||
| Parallelism adjustment of partitioned tables | |||
| TDE | |||
| Advanced R integration | |||
| Table and index partitioning |
|
- For more information about the feature differences among SQL Server 2016 Web, SQL Server 2016 SE, and SQL Server 2016 EE, see Editions and supported features of SQL Server 2016.
- For more information about the feature differences among SQL Server 2012 Web, SQL Server 2012 SE, and SQL Server 2012 EE, see Features Supported by the Editions of SQL Server 2012.