This topic describes the feature differences between the editions of ApsaraDB RDS for SQL Server.
Basic feature differences
Module | Feature | Cluster Edition | High-availability Series | Basic Edition | ||
2025 Enterprise Cluster Edition 2022 Enterprise Cluster Edition 2019 Enterprise Cluster Edition 2017 Enterprise Cluster Edition | 2025 Standard Edition 2022 Standard Edition 2019 Standard Edition 2017 Standard Edition 2016 Standard Edition, Enterprise Edition 2014 Standard Edition, Enterprise Edition 2012 Standard Edition, Enterprise Edition | 2008 R2 | 2025 Standard Edition, 2025 Enterprise Cluster Edition 2022 Web Edition, Standard Edition, Enterprise Cluster Edition 2019 Web Edition, Standard Edition, Enterprise Cluster Edition 2017 Web Edition, Standard Edition, Enterprise Cluster Edition 2016 Web Edition, Standard Edition, Enterprise Edition 2014 Standard Edition 2012 Web Edition, Enterprise Edition (single-node) | 2025 Enterprise Cluster Edition (read-only instance) 2022 Enterprise Cluster Edition (read-only instance) 2019 Enterprise Cluster Edition (read-only instance) 2017 Enterprise Cluster Edition (read-only instance) | ||
Lifecycle | Create instance | Supported | Supported | Supported | Supported | Supported |
Restart instance | ||||||
Auto-renewal | ||||||
Change billing method | ||||||
Change specifications | ||||||
Release instance | ||||||
Minor engine version update | Supported (Not supported for instances with disk encryption enabled) | Supported (Not supported for instances with disk encryption enabled) | Not supported | Supported (Not supported for instances with disk encryption enabled) | Cannot be upgraded separately (upgraded with the primary instance) | |
Major engine version upgrade | Supported | Supported | Supported | Supported | Cannot be upgraded separately (upgraded with the primary instance) | |
Clone instance | Supported (Not supported for shared instance types) | Supported (Not supported for shared instance types) | Not supported | Supported (Not supported for shared instance types) | Not supported | |
Create read-only instance | Supported | Not supported | Not supported | Not supported | Not supported | |
Instance properties | View instance list | Supported | Supported | Supported | Supported | Support |
View instance details | ||||||
Modify remarks | ||||||
Manage maintenance window | ||||||
Manage tags | ||||||
Migrate across zones | Supported (Not supported for primary instances with attached read-only instances) | Supported (Not supported for shared instance types) | Supported | Supported (Not supported for shared instance types) | Not supported | |
Database connection | VPC internal connection string | Supported | Supported | Supported | Support | Supported |
Public connection string | ||||||
Read-only connection string | Not supported | Not supported | Not supported | Not supported | Supported | |
Read-write splitting connection string | Not supported | Not supported | Not supported | Not supported | Not supported | |
Service availability | Intra-zone disaster recovery | Support | Supported | Supported | Supported | Not supported |
Zone-disaster recovery | Supported | Supported | Supported | Not supported | Not supported | |
Cross-region disaster recovery | Supported | Not supported | Not supported | Not supported | Not supported | |
Backup and recovery | Full backup | Supported | Supported | Supported | Supported | Not supported |
Incremental backup | ||||||
Log backup | ||||||
Customize backup policy | ||||||
Restore from backup set | ||||||
Point-in-time restore | ||||||
Restore from user backup set | Supported (full, differential, and log) | Supported (full, differential, and log) | Supported (full backup) | Supported (full, differential, and log) | Not supported | |
Clone and restore | Supported | Supported | Not supported | Support | Not supported | |
Back up specific databases and tables | Supported | Supported | Not supported | Supported | Not supported | |
Restore specific databases and tables | ||||||
Monitoring and Alerts | Resource Monitoring | Supported | Support | Supported | Support | Supported |
Engine monitoring | ||||||
Customize monitoring policy | ||||||
Monitoring aggregation | ||||||
Parameter management | Modify parameters | Supported | Supported | Supported | Supported | Support |
Log Management | Error log | Supported | Supported | Supported | Supported | Supported |
Data management feature differences
Module | Feature | Cluster Edition | High-availability Series | Basic Edition | ||
2025 Enterprise Cluster Edition 2022 Enterprise Cluster Edition 2019 Enterprise Cluster Edition 2017 Enterprise Cluster Edition | 2025 Standard Edition 2022 Standard Edition 2019 Standard Edition 2017 Standard Edition 2016 Standard Edition, Enterprise Edition 2014 Standard Edition, Enterprise Edition 2012 Standard Edition, Enterprise Edition | 2008 R2 | 2025 Standard Edition, 2025 Enterprise Cluster Edition 2022 Web Edition, Standard Edition, Enterprise Cluster Edition 2019 Web Edition, Standard Edition, Enterprise Cluster Edition 2017 Web Edition, Standard Edition, Enterprise Cluster Edition 2016 Web Edition, Standard Edition, Enterprise Edition 2014 Standard Edition 2012 Web Edition, Enterprise Edition (single-node) | 2022 Enterprise Cluster Edition (read-only instance) 2019 Enterprise Cluster Edition (read-only instance) 2017 Enterprise Cluster Edition (read-only instance) | ||
Data Management | User management | Supported | Supported | Supported | Supported | Not supported |
Database and table management | Supported | Supported | Supported | Supported | Not supported | |
Data operations | T-SQL only | T-SQL only | T-SQL only | T-SQL only | Data query only | |
Scheduled tasks | T-SQL only | T-SQL only | T-SQL only | T-SQL only | Not supported | |
Data integration (SSIS) | Supported (Not supported for shared instance types) | Supported (Not supported for shared instance types) | Not supported | Supported (Not supported for shared instance types) | Supported | |
Data analytics (SSAS) | ||||||
Data reporting (SSRS) | ||||||
Data migration and synchronization | Homogeneous data migration | Support for DTS | Supported by DTS | Supported by DTS | Supported by DTS | Not supported |
Heterogeneous data migration | ||||||
Data synchronization | ||||||
Change tracking | Not supported | Not supported | Not supported | Not supported | ||
Copy databases between instances | Supported | Supported | Not supported | Supported | Not supported | |
Data security | IP address whitelist | Supported | Supported | Supported | Supported | Supported |
Control plane operation audit | ||||||
Firewall | Supported (IP address whitelist) | Supported (IP address whitelist) | Supported (IP address whitelist) | Supported (IP address whitelist) | Supported (IP address whitelist) | |
Database audit | Supported | Supported | Supported | Supported | Supported | |
Disk encryption | Supported | Support | Not supported | Supported | Not supported (follows the primary instance) | |
Network encryption | Supported | Supported | Supported | Supported | Not supported (follows the primary instance) | |
Security group management | Not supported | Not supported | Not supported | Not supported | Supports configuring security groups, but does not support adding security group rules | |
Performance optimization | Storage management | Supported | Supported | Not supported | Supported | Supported |
Performance Insight | Supported | Supported | Not supported | Supported | Supported | |
Index analysis | Supported | Supported | Not supported | Supported | Supported | |
Deadlock analysis | Supported | Supported | Not supported | Supported | Supported | |
Slow Log Analysis | Supported | Supported | Not supported | Supported | Supported | |
Monitoring dashboard | Supported | Supported | Not supported | Supported | Supported | |
Official Microsoft edition differences
The following table describes the main feature differences between the Web, Standard, and Enterprise editions of SQL Server.
Feature | Standard Edition | Web Edition | Enterprise Edition |
Specifications | 24 cores, 128 GB | 16 cores, 64 GB | None |
High availability | Mirroring HA | Single-node | Always On high availability |
Data compression | Supported only in Standard Edition 2016 and later | Not supported | Supported |
SQL Profiler | |||
Change data capture (CDC) | |||
Columnstore index | |||
Online DDL | Not supported | ||
Parallel index operations | |||
Parallelism adjustment for partitioned tables | |||
TDE | |||
Advanced R integration | |||
Table and index partitioning |
|
For more information about the feature differences between the Web, Standard, and Enterprise editions of SQL Server, see the following topics:
SQL Server 2025: Editions and supported features of SQL Server 2025.
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: Features Supported by the Editions of SQL Server 2014.
SQL Server 2012: Features Supported by the Editions of SQL Server 2012.