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.