Features - ApsaraDB RDS - Alibaba Cloud Documentation Center

This topic provides an overview of the features that are provided by ApsaraDB RDS for SQL Server. In the following tables, ticks (️✔️) indicate that a feature is supported, and crosses (❌) indicate that a feature is not supported.

SQL Server 2019

Item	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE		Web
		RDS High-availability Edition	RDS Cluster Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️
Connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	✔️	✔️	❌	❌	❌	❌
	Read/write splitting	❌	✔️	✔️	❌	❌	❌	❌
	Read weight modification	❌	✔️	✔️	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️
	TDE setting	❌	✔️	✔️	✔️	✔️	❌	❌
	Distributed transaction whitelist setting	❌	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2017

Item	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE		Web
		RDS High-availability Edition	RDS Cluster Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️
Connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	✔️	✔️	❌	❌	❌	❌
	Read/write splitting	❌	✔️	✔️	❌	❌	❌	❌
	Read weight modification	❌	✔️	✔️	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️
	TDE setting	❌	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	❌	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2016

Item	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE				SQL Server SE		Web
		RDS High-availability Edition	RDS High-availability Edition		RDS Basic Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance upgrade	Upgrade from Basic Edition to High-availability Edition	❌	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Read/write splitting	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Read weight modification	❌	❌	❌	❌	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE setting	❌	✔️	✔️	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	❌	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2012

Item	Feature	SQL Server EE		SQL Server EE Basic		SQL Server SE		Web
		RDS High-availability Edition		RDS Basic Edition		RDS High-availability Edition		RDS Basic Edition
		Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance upgrade	Upgrade from Basic Edition to High-availability Edition	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Instance upgrade	Upgrade from SQL Server 2012 to SQL Server 2016	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌	❌	❌	❌	❌	❌
	Read/write splitting	❌	❌	❌	❌	❌	❌	❌	❌
	Read weight modification	❌	❌	❌	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE setting	✔️	✔️	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	✔️	✔️	❌	❌	✔️	✔️	❌	❌
Auditing	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2008 R2

Item	Feature	RDS High-availability Edition
Item	Feature	Local SSD	Standard SSD	PL1 ESSD to PL3 ESSD
Data migration	Data migration	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️
	Cross-zone migration	✔️	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️
	Instance suspension	❌	✔️	✔️
	Instance restart	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️
	DBCC	❌	✔️	✔️
Instance upgrade	Upgrade from SQL Server 2008 R2 to SQL Server 2012 or SQL Server 2016	✔️	❌	❌
Account management	Account creation	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️
	Service account authorization	✔️	❌	❌
	Account deletion	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️
Connection management	Instance connection	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️
	vSwitch change	❌	✔️	✔️
	Public endpoint application	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌
	Read/write splitting	❌	❌	❌
	Read weight modification	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️
	SSL encryption setting	✔️	✔️	✔️
	TDE setting	✔️	✔️	✔️
	Distributed transaction whitelist setting	❌	❌	❌
	Cloud disk encryption	❌	✔️	✔️
Auditing	SQL Audit	✔️	✔️	✔️
	Log management	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️
	Cross-region backup	❌	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️
Data restoration	Data restoration	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	❌	❌
Tag management	Tag creation	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️