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 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 | |||||
| Manage 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 | |
| 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 | |||||
| Customize backup policies for an RDS instance | |||||
| Restore the data of an RDS instance from a data backup file that is stored on another RDS instance | |||||
| Restore the data of an RDS instance to a specific point in time | |||||
| Restore the data of an RDS instance from a data backup file that is stored on your computer | 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 cloned 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 2019 EE 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) |
| Database 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 Edition, Standard Edition, and Enterprise Edition.
| Feature | Microsoft SQL Server Web Edition | Microsoft SQL Server Standard Edition | Microsoft SQL Server Enterprise Edition |
|---|---|---|---|
| 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 | 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 |
- For more information about the feature differences between SQL Server 2016 Web Edition, Standard Edition, and Enterprise Edition), see Editions and supported features of SQL Server 2016.
- For more information about the feature differences between SQL Server 2012 Web Edition, Standard Edition, and Enterprise Edition), see Features Supported by the Editions of SQL Server 2012.
- For more information about the feature differences between various SQL Server editions, see Addressing Key Business Needs Efficiently and Cost-Effectively with Different Editions of ApsaraDB For SQL Server. This article is written by Alibaba Cloud engineers.