This topic provides an overview of the features supported in different SQL Server versions, RDS editions, and storage types of ApsaraDB RDS for SQL Server.
SQL Server 2019
SQL Server 2017
| Category | Feature | SQL Server 2017 | |||
|---|---|---|---|---|---|
| Enterprise Edition | Standard Edition | ||||
| Cluster Edition | High-availability Edition | ||||
| Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | ||
| Data migration | Migrate the data of an RDS instance | Supported | Supported | Supported | Supported |
| Instance management | Create an RDS instance | Supported | Supported | Supported | Supported |
| Change the specifications of an RDS instance | Supported | Supported | Supported | Supported | |
| Migrate an RDS instance across zones | Not supported | Not supported | Not supported | Not supported | |
| Switch over services between a primary RDS instance and its secondary instance | Supported | Supported | Supported | Supported | |
| Restart an RDS instance | Supported | Supported | Supported | Supported | |
| Set the maintenance window | Supported | Supported | Supported | Supported | |
| Release an RDS instance | Supported | Supported | Supported | Supported | |
| Instance recycle bin | Supported | Supported | Supported | Supported | |
| DBCC | Supported | Supported | Supported | Supported | |
| Account management | Create an account for an RDS instance | Supported | Supported | Supported | Supported |
| Reset the password of an account for an RDS instance | Supported | Supported | Supported | Supported | |
| Modify the permissions of an account for an RDS instance | Supported | Supported | Supported | Supported | |
| Authorize the service account of an RDS instance | Not supported | Not supported | Not supported | Not supported | |
| Delete an account for an RDS instance | Supported | Supported | Supported | Supported | |
| Database management | Create a database | Supported | Supported | Supported | Supported |
| Delete a database | Supported | Supported | Supported | Supported | |
| Copy a database | Supported | Supported | Supported | Supported | |
| Database connection | Connect to an RDS instance | Supported | Supported | Supported | Supported |
| Configure endpoints for an RDS instance | Supported | Supported | Supported | Supported | |
| View the endpoints and ports of an RDS instance | Supported | Supported | Supported | Supported | |
| Apply for a public endpoint for an RDS instance | Supported | Supported | Supported | Supported | |
| Monitoring and alerting | View monitoring data of an RDS instance | Supported | Supported | Supported | Supported |
| Set the monitoring frequency of an RDS instance | Supported | Supported | Supported | Supported | |
| Configure alert rules | Supported | Supported | Supported | Supported | |
| Network management | Change the network type of an RDS instance | Not supported | Not supported | Not supported | Not supported |
| Read-only instance and read/write splitting | Create a read-only instance | Supported | Supported | Not supported | Not supported |
| Enable read/write splitting for an RDS instance | Supported | Supported | Not supported | Not supported | |
| Modify the read weights of read-only instances | Supported | Supported | Not supported | Not supported | |
| Security management | Configure a whitelist for an RDS instance | Supported | Supported | Supported | Supported |
| Configure SSL encryption for an RDS instance | Supported | Supported | Supported | Supported | |
| Configure TDE for an RDS instance | Supported | Supported | Not supported | Not supported | |
| Configure a distributed transaction whitelist for an RDS instance | Not supported | Not supported | Supported | Supported | |
| Audit | Log management | Not supported | Not supported | Not supported | Not supported |
| Database backup | Back up the data of an RDS instance | Supported | Supported | Supported | Supported |
| A free tier of backup space for an RDS instance | Supported | Supported | Supported | Supported | |
| Download a data backup of an RDS instance | Supported | Supported | Supported | Supported | |
| Database restoration | Restore the data of an RDS instance | Supported | Supported | Supported | Supported |
| Tag management | Create tags | Supported | Supported | Supported | Supported |
| Delete tags | Supported | Supported | Supported | Supported | |
| Filter RDS instances by tag | Supported | Supported | Supported | Supported | |
SQL Server 2016
| Category | Feature | SQL Server 2016 | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Enterprise Edition | Standard Edition | Web | |||||||
| High-availability Edition | Basic Edition | High-availability Edition | Basic Edition | ||||||
| Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | Standard SSD | ESSD | Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | Standard SSD | ESSD | ||
| Data migration | Migrate the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Instance management | Create an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Change the specifications of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Migrate an RDS instance across zones | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Switch over services between a primary RDS instance and its secondary instance | Supported | Supported | Not supported | Not supported | Supported | Supported | Not supported | Not supported | |
| Restart an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Set the maintenance window | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Release an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Instance recycle bin | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| DBCC | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Instance upgrade | Upgrade an RDS instance from Basic Edition to High-availability Edition | Not supported | Not supported | Supported | Supported | Not supported | Not supported | Supported | Supported |
| Account management | Create an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Reset the password of an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Modify the permissions of an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Authorize the service account of an RDS instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Delete an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database management | Create a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Delete a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Copy a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database connection | Connect to an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Configure endpoints for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| View the endpoints and ports of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Apply for a public endpoint for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Monitoring and alerting | View monitoring data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Set the monitoring frequency of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Configure alert rules | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Network management | Change the network type of an RDS instance | Not supported | Not supported | Supported | Supported | Not supported | Not supported | Supported | Supported |
| Read-only instance and read/write splitting | Create a read-only instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported |
| Enable read/write splitting for an RDS instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Modify the read weights of read-only instances | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Security management | Configure a whitelist for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Configure SSL encryption for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Configure TDE for an RDS instance | Supported | Supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Configure a distributed transaction whitelist for an RDS instance | Supported | Supported | Not supported | Not supported | Supported | Supported | Not supported | Not supported | |
| Audit | Log management | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported |
| Database backup | Back up the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| A free tier of backup space for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Download a data backup of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database restoration | Restore the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Tag management | Create tags | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Delete tags | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Filter RDS instances by tag | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
SQL Server 2012
| Category | Feature | SQL Server 2012 | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Enterprise Edition | Enterprise Edition Basic | Standard Edition | Web | ||||||
| High-availability Edition | Basic Edition | High-availability Edition | Basic Edition | ||||||
| Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | Standard SSD | ESSD | Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | Standard SSD | ESSD | ||
| Data migration | Migrate the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Instance management | Create an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Change the specifications of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Migrate an RDS instance across zones | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Switch over services between a primary RDS instance and its secondary instance | Supported | Supported | Not supported | Not supported | Supported | Supported | Not supported | Not supported | |
| Restart an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Set the maintenance window | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Release an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Instance recycle bin | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| DBCC | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Instance upgrade | Upgrade an RDS instance from Basic Edition to High-availability Edition | Not supported | Not supported | Supported | Supported | Not supported | Not supported | Supported | Supported |
| Upgrade an RDS instance from SQL Server 2012 to SQL Server 2016 | Not supported | Not supported | Supported | Supported | Not supported | Not supported | Supported | Supported | |
| Account management | Create an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Reset the password of an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Modify the permissions of an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Authorize the service account of an RDS instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Delete an account for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database management | Create a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Delete a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Copy a database | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database connection | Connect to an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Configure endpoints for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| View the endpoints and ports of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Apply for a public endpoint for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Monitoring and alerting | View monitoring data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Set the monitoring frequency of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Configure alert rules | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Network management | Change the network type of an RDS instance | Not supported | Not supported | Supported | Supported | Not supported | Not supported | Supported | Supported |
| Read-only instance and read/write splitting | Create a read-only instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported |
| Enable read/write splitting for an RDS instance | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Modify the read weights of read-only instances | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | |
| Security management | Configure a whitelist for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Configure SSL encryption for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Configure TDE for an RDS instance | Supported | Supported | Supported | Supported | Not supported | Not supported | Not supported | Not supported | |
| Configure a distributed transaction whitelist for an RDS instance | Supported | Supported | Not supported | Not supported | Supported | Supported | Not supported | Not supported | |
| Audit | Log management | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported |
| Database backup | Back up the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| A free tier of backup space for an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Download a data backup of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Database restoration | Restore the data of an RDS instance | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Tag management | Create tags | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Delete tags | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
| Filter RDS instances by tag | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | |
SQL Server 2008 R2
| Category | Feature | SQL Server 2008 R2 | ||
|---|---|---|---|---|
| High-availability Edition | ||||
| Local SSD | Standard SSD | ESSD, ESSD PL2, or ESSD PL3 | ||
| Data migration | Migrate the data of an RDS instance | Supported | Supported | Supported |
| Instance management | Create an RDS instance | Supported | Supported | Supported |
| Change the specifications of an RDS instance | Supported | Supported | Supported | |
| Migrate an RDS instance across zones | Supported | Not supported | Not supported | |
| Switch over services between a primary RDS instance and its secondary instance | Supported | Supported | Supported | |
| Restart an RDS instance | Supported | Supported | Supported | |
| Set the maintenance window | Supported | Supported | Supported | |
| Release an RDS instance | Supported | Supported | Supported | |
| Instance recycle bin | Supported | Supported | Supported | |
| DBCC | Not supported | Supported | Supported | |
| Instance upgrade | Upgrade an RDS instance from SQL Server 2008 R2 to SQL Server 2012 or SQL Server 2016 | Supported | Not supported | Not supported |
| Account management | Create an account for an RDS instance | Supported | Supported | Supported |
| Reset the password of an account for an RDS instance | Supported | Supported | Supported | |
| Modify the permissions of an account for an RDS instance | Supported | Supported | Supported | |
| Authorize the service account of an RDS instance | Supported | Not supported | Not supported | |
| Delete an account for an RDS instance | Supported | Supported | Supported | |
| Database management | Create a database | Supported | Supported | Supported |
| Delete a database | Supported | Supported | Supported | |
| Copy a database | Supported | Supported | Supported | |
| Database connection | Connect to an RDS instance | Supported | Supported | Supported |
| Configure endpoints for an RDS instance | Supported | Supported | Supported | |
| View the endpoints and ports of an RDS instance | Supported | Supported | Supported | |
| Apply for a public endpoint for an RDS instance | Supported | Supported | Supported | |
| Monitoring and alerting | View monitoring data of an RDS instance | Supported | Supported | Supported |
| Set the monitoring frequency of an RDS instance | Supported | Supported | Supported | |
| Configure alert rules | Supported | Supported | Supported | |
| Network management | Change the network type of an RDS instance | Not supported | Not supported | Not supported |
| Read-only instance and read/write splitting | Create a read-only instance | Not supported | Not supported | Not supported |
| Enable read/write splitting for an RDS instance | Not supported | Not supported | Not supported | |
| Modify the read weights of read-only instances | Not supported | Not supported | Not supported | |
| Security management | Configure a whitelist for an RDS instance | Supported | Supported | Supported |
| Configure SSL encryption for an RDS instance | Supported | Supported | Supported | |
| Configure TDE for an RDS instance | Supported | Supported | Supported | |
| Configure a distributed transaction whitelist for an RDS instance | Not supported | Not supported | Not supported | |
| Audit | Log management | Supported | Not supported | Not supported |
| Database backup | Back up the data of an RDS instance | Supported | Supported | Supported |
| A free tier of backup space for an RDS instance | Supported | Supported | Supported | |
| Download a data backup of an RDS instance | Supported | Supported | Supported | |
| Database restoration | Restore the data of an RDS instance | Supported | Supported | Supported |
| Tag management | Create tags | Supported | Supported | Supported |
| Delete tags | Supported | Supported | Supported | |
| Filter RDS instances by tag | Supported | Supported | Supported | |