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 2022 EE (Always On) SQL Server 2019 EE (Always On) SQL Server 2017 EE (Always On) | SQL Server 2022 SE SQL Server 2019 SE SQL Server 2017 SE SQL Server 2016 SE and SQL Server 2016 EE SQL Server 2014 SE and SQL Server 2014 EE SQL Server 2012 SE and SQL Server 2012 EE | SQL Server 2008 R2 | SQL Server 2022 Web and SQL Server 2022 SE SQL Server 2019 Web and SQL Server 2019 SE SQL Server 2017 Web and SQL Server 2017 SE SQL Server 2016 Web, SQL Server 2016 SE, and SQL Server 2016 EE SQL Server 2014 SE SQL Server 2012 Web and SQL Server 2012 EE Basic | ||
Lifecycle | Instance creation | Supported | Supported | Supported | Supported |
Instance restart | |||||
Auto-renewal | |||||
Billing method change | |||||
Specification 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 instance details | |||||
Description modification | |||||
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 set | |||||
Restoration by point in time | |||||
Restoration by user 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) | |
Restoration by using a cloned instance | Supported | Supported | Not supported | Supported | |
Backup of individual databases and tables | Supported | Supported | Not supported | Supported | |
Restoration of individual databases and tables | |||||
Monitoring and alerting | Resource monitoring | Supported | Supported | Supported | Supported |
Engine monitoring | |||||
Monitoring policy customization | |||||
Monitoring aggregation | |||||
Manage parameters | 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) |
Data management features
Category | Feature | RDS Cluster Edition | RDS High-availability Edition | RDS Basic Edition | |
SQL Server 2022 EE (Always On) SQL Server 2019 EE (Always On) SQL Server 2017 EE (Always On) | SQL Server 2022 SE SQL Server 2019 SE SQL Server 2017 SE SQL Server 2016 SE and SQL Server 2016 EE SQL Server 2014 SE and SQL Server 2014 EE SQL Server 2012 SE and SQL Server 2012 EE | SQL Server 2008 R2 | SQL Server 2022 Web and SQL Server 2022 SE SQL Server 2019 Web and SQL Server 2019 SE SQL Server 2017 Web and SQL Server 2017 SE SQL Server 2016 Web, SQL Server 2016 SE, and SQL Server 2016 EE SQL Server 2014 SE SQL Server 2012 Web and SQL Server 2012 EE Basic | ||
Data management | User management | Supported | Supported | Supported | Supported |
Database and table management | Supported | Supported | Supported | Supported | |
Data operation | Supported (only T-SQL) | Supported (only T-SQL) | Supported (only T-SQL) | Supported (only T-SQL) | |
Scheduled task | Supported (only T-SQL) | Supported (only T-SQL) | Supported (only T-SQL) | Supported (only T-SQL) | |
SQL Server Integration Services (SSIS) | Supported (Shared instance types are not supported.) | Supported (Shared instance types are not supported.) | Not supported | Supported (Shared instance types are not supported.) | |
SQL Server Analysis Services (SSAS) | |||||
SQL Server Reporting Services (SSRS) | |||||
Data migration and synchronization | Homogeneous data migration | Supported (DTS) | Supported (DTS) | Supported (DTS) | Supported (DTS) |
Heterogeneous data migration | |||||
Data synchronization | |||||
Change tracking | 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 | |
Cloud disk encryption | Supported | Supported | Not supported | Supported | |
Network encryption | Supported | Supported | Supported | Supported | |
Security group management | Not supported | Not supported | Not supported | Not supported | |
Performance improvement | Storage capacity management | Supported | Supported | Not supported | Supported |
Performance insight | Supported | Supported | Not supported | Supported | |
Index-based analysis | Supported | Supported | Not supported | Supported | |
Deadlock analysis | Supported | Supported | Not supported | Supported | |
Slow query log analysis | Supported | Supported | Not supported | Supported | |
Monitoring dashboard | Supported | Supported | Not supported | Supported | |
Features provided by Microsoft SQL Server
The following table describes the features that are provided by Microsoft SQL Server Web, Microsoft SQL Server SE, and Microsoft SQL Server EE.
Feature | SQL Server SE | SQL Server Web | SQL Server EE |
Specifications | 24 cores and 128 GB | 16 cores and 64 GB | None |
High availability (HA) | Mirror HA | Standalone | Always On HA |
Data compression | The features are supported for SQL Server 2016 SE and later SQL Server SE. | Not supported | 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 differences between the official editions (Web Edition, Standard Edition, and Enterprise Edition) of SQL Server, see the following topics:
SQL Server 2022: Editions and supported features of SQL Server 2022
SQL Server 2019: Editions and supported features of SQL Server 2019
SQL Server 2017: Editions and supported features of SQL Server 2017
SQL Server 2016: Editions and supported features of SQL Server 2016
SQL Server 2014: Editions and supported features of SQL Server 2014
SQL Server 2012: Editions and supported features of SQL Server 2012