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