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

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

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