This topic provides an overview of the features that are supported in different SQL Server versions, RDS editions, and storage types of ApsaraDB RDS for SQL Server.

Note In the following tables, the check sign (√) indicates that the feature is supported, and the cross sign (×) indicates that the feature is not supported.

SQL Server 2019

Category Feature SQL Server 2019
SE
RDS High-availability Edition
Standard SSD ESSD, ESSD PL2, or ESSD PL3
Data migration Migrate the data of an RDS instance √ √
Instance management Create an RDS instance √ √
Change the specifications of an RDS instance √ √
Migrate an RDS instance across zones × ×
Switch over services between primary and secondary RDS instances √ √
Restart an RDS instance √ √
Set the maintenance window of an RDS instance √ √
Release an RDS instance √ √
Manage ApsaraDB RDS for SQL Server instances in the recycle bin √ √
DBCC √ √
Account management Create an account on an RDS instance √ √
Reset the password of an account on an RDS instance √ √
Modify the permissions of an account on an RDS instance √ √
Authorize the service account of an RDS instance × ×
Delete an account from an RDS instance √ √
Database management Create a database on an RDS instance √ √
Delete a database from an RDS instance √ √
Copy a database between RDS instances √ √
Database connection Connect to an RDS instance √ √
Configure an endpoint for an RDS instance √ √
View the endpoints and ports of an RDS instance √ √
Apply for a public endpoint for an RDS instance √ √
Monitoring and alerting View the monitoring data of an RDS instance √ √
Set the monitoring frequency of an RDS instance √ √
Configure an alert rule for an RDS instance √ √
Network management Change the network type of an RDS instance × ×
Read-only instance and read/write splitting Create a read-only RDS instance × ×
Enable read/write splitting for an RDS instance × ×
Modify the read weights of read-only RDS instances × ×
Security management Control access to an RDS instance √ √
Configure SSL encryption for an RDS instance √ √
Configure TDE for an RDS instance × ×
Configure a distributed transaction whitelist for an RDS instance √ √
Audit View the logs of an RDS instance × ×
Backup Back up the data of an RDS instance √ √
Back up an ApsaraDB RDS for SQL Server instance across regions √ √
Free quota for backup storage √ √
Download a backup file of an RDS instance √ √
Restoration Restore the data of an RDS instance √ √
Tag management Create tags √ √
Delete tags √ √
Use tags to filter ApsaraDB RDS for SQL Server instances √ √

SQL Server 2017

Category Feature SQL Server 2017
EE SE
RDS Cluster Edition RDS 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 √ √ √ √
Instance management Create an RDS instance √ √ √ √
Change the specifications of an RDS instance √ √ √ √
Migrate an RDS instance across zones × × × ×
Switch over services between primary and secondary RDS instances √ √ √ √
Restart an RDS instance √ √ √ √
Set the maintenance window of an RDS instance √ √ √ √
Release an RDS instance √ √ √ √
Manage ApsaraDB RDS for SQL Server instances in the recycle bin √ √ √ √
DBCC √ √ √ √
Account management Create an account on an RDS instance √ √ √ √
Reset the password of an account on an RDS instance √ √ √ √
Modify the permissions of an account on an RDS instance √ √ √ √
Authorize the service account of an RDS instance × × × ×
Delete an account from an RDS instance √ √ √ √
Database management Create a database on an RDS instance √ √ √ √
Delete a database from an RDS instance √ √ √ √
Copy a database between RDS instances √ √ √ √
Database connection Connect to an RDS instance √ √ √ √
Configure an endpoint for an RDS instance √ √ √ √
View the endpoints and ports of an RDS instance √ √ √ √
Apply for a public endpoint for an RDS instance √ √ √ √
Monitoring and alerting View the monitoring data of an RDS instance √ √ √ √
Set the monitoring frequency of an RDS instance √ √ √ √
Configure an alert rule for an RDS instance √ √ √ √
Network management Change the network type of an RDS instance × × × ×
Read-only instance and read/write splitting Create a read-only RDS instance √ √ × ×
Enable read/write splitting for an RDS instance √ √ × ×
Modify the read weights of read-only RDS instances √ √ × ×
Security management Control access to an RDS instance √ √ √ √
Configure SSL encryption for an RDS instance √ √ √ √
Configure TDE for an RDS instance √ √ × ×
Configure a distributed transaction whitelist for an RDS instance × × √ √
Audit View the logs of an RDS instance × × × ×
Backup Back up the data of an RDS instance √ √ √ √
Back up an ApsaraDB RDS for SQL Server instance across regions √ √ √ √
Free quota for backup storage √ √ √ √
Download a backup file of an RDS instance √ √ √ √
Restoration Restore the data of an RDS instance √ √ √ √
Tag management Create tags √ √ √ √
Delete tags √ √ √ √
Use tags to filter ApsaraDB RDS for SQL Server instances √ √ √ √

SQL Server 2016

Category Feature SQL Server 2016
EE SE WEB
RDS High-availability Edition RDS Basic Edition RDS High-availability Edition RDS 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 √ √ √ √ √ √ √ √
Instance management Create an RDS instance √ √ √ √ √ √ √ √
Change the specifications of an RDS instance √ √ √ √ √ √ √ √
Migrate an RDS instance across zones × × × × × × × ×
Switch over services between primary and secondary RDS instances √ √ × × √ √ × ×
Restart an RDS instance √ √ √ √ √ √ √ √
Set the maintenance window of an RDS instance √ √ √ √ √ √ √ √
Release an RDS instance √ √ √ √ √ √ √ √
Manage ApsaraDB RDS for SQL Server instances in the recycle bin √ √ √ √ √ √ √ √
DBCC √ √ √ √ √ √ √ √
Instance upgrade Upgrade an RDS instance from the Basic Edition to the High-availability Edition × × √ √ × × √ √
Account management Create an account on an RDS instance √ √ √ √ √ √ √ √
Reset the password of an account on an RDS instance √ √ √ √ √ √ √ √
Modify the permissions of an account on an RDS instance √ √ √ √ √ √ √ √
Authorize the service account of an RDS instance × × × × × × × ×
Delete an account from an RDS instance √ √ √ √ √ √ √ √
Database management Create a database on an RDS instance √ √ √ √ √ √ √ √
Delete a database from an RDS instance √ √ √ √ √ √ √ √
Copy a database between RDS instances √ √ √ √ √ √ √ √
Database connection Connect to an RDS instance √ √ √ √ √ √ √ √
Configure an endpoint for an RDS instance √ √ √ √ √ √ √ √
View the endpoints and ports of an RDS instance √ √ √ √ √ √ √ √
Apply for a public endpoint for an RDS instance √ √ √ √ √ √ √ √
Monitoring and alerting View the monitoring data of an RDS instance √ √ √ √ √ √ √ √
Set the monitoring frequency of an RDS instance √ √ √ √ √ √ √ √
Configure an alert rule for an RDS instance √ √ √ √ √ √ √ √
Network management Change the network type of an RDS instance × × √ √ × × √ √
Read-only instance and read/write splitting Create a read-only RDS instance × × × × × × × ×
Enable read/write splitting for an RDS instance × × × × × × × ×
Modify the read weights of read-only RDS instances × × × × × × × ×
Security management Control access to an RDS instance √ √ √ √ √ √ √ √
Configure SSL encryption for an RDS instance √ √ √ √ √ √ √ √
Configure TDE for an RDS instance √ √ √ √ × × × ×
Configure a distributed transaction whitelist for an RDS instance √ √ × × √ √ × ×
Audit View the logs of an RDS instance × × × × × × × ×
Backup Back up the data of an RDS instance √ √ √ √ √ √ √ √
Back up an ApsaraDB RDS for SQL Server instance across regions √ √ √ √ √ √ √ √
Free quota for backup storage √ √ √ √ √ √ √ √
Download a backup file of an RDS instance √ √ √ √ √ √ √ √
Restoration Restore the data of an RDS instance √ √ √ √ √ √ √ √
Tag management Create tags √ √ √ √ √ √ √ √
Delete tags √ √ √ √ √ √ √ √
Use tags to filter ApsaraDB RDS for SQL Server instances √ √ √ √ √ √ √ √

SQL Server 2012

Category Feature SQL Server 2012
EE EE Basic SE WEB
RDS High-availability Edition RDS Basic Edition RDS High-availability Edition RDS 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 √ √ √ √ √ √ √ √
Instance management Create an RDS instance √ √ √ √ √ √ √ √
Change the specifications of an RDS instance √ √ √ √ √ √ √ √
Migrate an RDS instance across zones × × × × × × × ×
Switch over services between primary and secondary RDS instances √ √ × × √ √ × ×
Restart an RDS instance √ √ √ √ √ √ √ √
Set the maintenance window of an RDS instance √ √ √ √ √ √ √ √
Release an RDS instance √ √ √ √ √ √ √ √
Manage ApsaraDB RDS for SQL Server instances in the recycle bin √ √ √ √ √ √ √ √
DBCC √ √ √ √ √ √ √ √
Instance upgrade Upgrade an RDS instance from the Basic Edition to the High-availability Edition × × √ √ × × √ √
Upgrade an RDS instance from SQL Server 2012 to SQL Server 2016 × × √ √ × × √ √
Account management Create an account on an RDS instance √ √ √ √ √ √ √ √
Reset the password of an account on an RDS instance √ √ √ √ √ √ √ √
Modify the permissions of an account on an RDS instance √ √ √ √ √ √ √ √
Authorize the service account of an RDS instance × × × × × × × ×
Delete an account from an RDS instance √ √ √ √ √ √ √ √
Database management Create a database on an RDS instance √ √ √ √ √ √ √ √
Delete a database from an RDS instance √ √ √ √ √ √ √ √
Copy a database between RDS instances √ √ √ √ √ √ √ √
Database connection Connect to an RDS instance √ √ √ √ √ √ √ √
Configure an endpoint for an RDS instance √ √ √ √ √ √ √ √
View the endpoints and ports of an RDS instance √ √ √ √ √ √ √ √
Apply for a public endpoint for an RDS instance √ √ √ √ √ √ √ √
Monitoring and alerting View the monitoring data of an RDS instance √ √ √ √ √ √ √ √
Set the monitoring frequency of an RDS instance √ √ √ √ √ √ √ √
Configure an alert rule for an RDS instance √ √ √ √ √ √ √ √
Network management Change the network type of an RDS instance × × √ √ × × √ √
Read-only instance and read/write splitting Create a read-only RDS instance × × × × × × × ×
Enable read/write splitting for an RDS instance × × × × × × × ×
Modify the read weights of read-only RDS instances × × × × × × × ×
Security management Control access to an RDS instance √ √ √ √ √ √ √ √
Configure SSL encryption for an RDS instance √ √ √ √ √ √ √ √
Configure TDE for an RDS instance √ √ √ √ × × × ×
Configure a distributed transaction whitelist for an RDS instance √ √ × × √ √ × ×
Audit View the logs of an RDS instance × × × × × × × ×
Backup Back up the data of an RDS instance √ √ √ √ √ √ √ √
Back up an ApsaraDB RDS for SQL Server instance across regions √ √ √ √ √ √ √ √
Free quota for backup storage √ √ √ √ √ √ √ √
Download a backup file of an RDS instance √ √ √ √ √ √ √ √
Restoration Restore the data of an RDS instance √ √ √ √ √ √ √ √
Tag management Create tags √ √ √ √ √ √ √ √
Delete tags √ √ √ √ √ √ √ √
Use tags to filter ApsaraDB RDS for SQL Server instances √ √ √ √ √ √ √ √

SQL Server 2008 R2

Category Feature SQL Server 2008 R2
RDS High-availability Edition
Local SSD Standard SSD ESSD, ESSD PL2, or ESSD PL3
Data migration Migrate the data of an RDS instance √ √ √
Instance management Create an RDS instance √ √ √
Change the specifications of an RDS instance √ √ √
Migrate an RDS instance across zones √ × ×
Switch over services between primary and secondary RDS instances √ √ √
Restart an RDS instance √ √ √
Set the maintenance window of an RDS instance √ √ √
Release an RDS instance √ √ √
Manage ApsaraDB RDS for SQL Server instances in the recycle bin √ √ √
DBCC × √ √
Instance upgrade Upgrade an RDS instance from SQL Server 2008 R2 to SQL Server 2012 or SQL Server 2016 √ × ×
Account management Create an account on an RDS instance √ √ √
Reset the password of an account on an RDS instance √ √ √
Modify the permissions of an account on an RDS instance √ √ √
Authorize the service account of an RDS instance √ × ×
Delete an account from an RDS instance √ √ √
Database management Create a database on an RDS instance √ √ √
Delete a database from an RDS instance √ √ √
Copy a database between RDS instances √ √ √
Database connection Connect to an RDS instance √ √ √
Configure an endpoint for an RDS instance √ √ √
View the endpoints and ports of an RDS instance √ √ √
Apply for a public endpoint for an RDS instance √ √ √
Monitoring and alerting View the monitoring data of an RDS instance √ √ √
Set the monitoring frequency of an RDS instance √ √ √
Configure an alert rule for an RDS instance √ √ √
Network management Change the network type of an RDS instance × × ×
Read-only instance and read/write splitting Create a read-only RDS instance × × ×
Enable read/write splitting for an RDS instance × × ×
Modify the read weights of read-only RDS instances × × ×
Security management Control access to an RDS instance √ √ √
Configure SSL encryption for an RDS instance √ √ √
Configure TDE for an RDS instance √ √ √
Configure a distributed transaction whitelist for an RDS instance × × ×
Audit View the logs of an RDS instance √ × ×
Backup Back up the data of an RDS instance √ √ √
Back up an ApsaraDB RDS for SQL Server instance across regions × √ √
Free quota for backup storage √ √ √
Download a backup file of an RDS instance √ √ √
Restoration Restore the data of an RDS instance √ √ √
Tag management Create tags √ √ √
Delete tags √ √ √
Use tags to filter ApsaraDB RDS for SQL Server instances √ √ √