Features

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.

Note

ApsaraDB RDS for SQL Server supports multiple versions and editions of SQL Server, such as SQL Server 2022, SQL Server 2019, SQL Server EE, SQL Server SE, and SQL Server Web. Each SQL Server edition provides different capabilities in computing scale, high availability, parallel processing and performance optimization, data security, management and development, and data warehousing. For more information, see Features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions.
The features of SQL Server versions that are supported by ApsaraDB RDS may be different from the features of Microsoft SQL Server versions. For more information, see Microsoft documentation.
Serverless RDS instances support SQL Server 2016 SE, SQL Server 2017 SE, and SQL Server 2019 SE. For more information, see Overview.
You can create standard RDS instances that run RDS Basic Edition only in regions outside China.

SQL Server 2022

SQL Server 2019

SQL Server 2017

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

Category	Feature	SQL Server EE	SQL Server SE		SQL Server Web
		RDS Cluster Edition	RDS Basic Edition	RDS High-availability Edition	RDS Basic Edition
		PL1 ESSD to PL3 ESSD	PL1 ESSD to PL3 ESSD	PL1 ESSD to PL3 ESSD	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	✔️	✔️	✔️	✔️
Account management	Creation of a standard account or a privileged account	✔️	✔️	✔️	✔️
	Creation of a system admin account	✔️	✔️	✔️	✔️
	Host account creation for logons	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️	✔️
	Data archive to OSS	❌	✔️	❌	✔️
	Database attribute management	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️
	Endpoint and port number 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	✔️	❌	❌	❌
	Secondary instance restart	✔️	❌	❌	❌
	Read attribute configuration for a secondary instance	✔️	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️
	SSL encryption	✔️	✔️	✔️	✔️
	TDE configuration	✔️	✔️	✔️	❌
	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	✔️	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️

Category	Feature	Serverless instance	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE			Web
		RDS High-availability Edition	RDS Cluster Edition		RDS Basic Edition	RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	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	Creation of a standard account or a privileged account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Creation of a system admin account	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Host account creation for logons	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Data archive to OSS	❌	❌	❌	✔️	❌	❌	❌	✔️
	Database attribute management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port number 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	❌	✔️	✔️	❌	❌	❌	❌	❌
	Secondary instance restart	❌	✔️	✔️	❌	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	✔️	✔️	✔️	❌	❌
	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	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Category	Feature	Serverless instance	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE			Web
		RDS High-availability Edition	RDS Cluster Edition		RDS Basic Edition	RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	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	Creation of a standard account or a privileged account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Creation of a system admin account	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Host account creation for logons	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Data archive to OSS	❌	❌	❌	✔️	❌	❌	❌	✔️
	Database attribute management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port number 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	❌	✔️	✔️	❌	❌	❌	❌	❌
	Secondary instance restart	❌	✔️	✔️	❌	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	❌	❌	❌	❌	❌
	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	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Category	Feature	Serverless instance	Regular instance
		SQL Server SE	SQL Server EE				SQL Server SE			Web
		RDS High-availability Edition	RDS High-availability Edition		RDS Basic Edition		RDS Basic Edition RDS edition	RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	ESSD	PL1 ESSD to PL3 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 RDS Basic Edition to RDS High-availability Edition	❌	❌	❌	✔️	✔️	✔️	❌	❌	✔️	✔️
Account management	Creation of a standard account or a privileged account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Creation of a system admin account	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Host account creation for logons	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Data archive to OSS	❌	❌	❌	❌	✔️	✔️	❌	❌	❌	✔️
	Database attribute management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port number 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	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	✔️	✔️	❌	❌	❌	❌	❌
	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	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Category	Feature	SQL Server EE	SQL Server SE
		RDS High-availability Edition	RDS Basic Edition	RDS High-availability Edition
		PL1 ESSD to PL3 ESSD	PL1 ESSD to PL3 ESSD	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 RDS Basic Edition to RDS High-availability Edition	❌	✔️	❌
Account management	Creation of a standard account or a privileged account	✔️	✔️	✔️
	Creation of a system admin account	✔️	✔️	✔️
	Host account creation for logons	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️
	Service account authorization	❌	❌	❌
	Account deletion	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️
	Data archive to OSS	❌	✔️	❌
	Database attribute management	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️
	Endpoint and port number 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	✔️	✔️	✔️
	TDE configuration	✔️	❌	❌
	Distributed transaction whitelist setting	✔️	✔️	✔️
	Cloud disk encryption	✔️	✔️	✔️
Auditing	SQL Audit	✔️	✔️	✔️
	Log management	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️
	Sparse backup	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️

Category	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 RDS Basic Edition to RDS High-availability Edition	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Instance upgrade	Upgrade from SQL Server 2012 to SQL Server 2016	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Account management	Creation of a standard account or a privileged account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Creation of a system admin account	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Host account creation for logons	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Data archive to OSS	❌	❌	❌	✔️	❌	❌	❌	✔️
	Database attribute management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port number 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	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	✔️	✔️	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌
Auditing	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Category	Feature	RDS High-availability Edition
Category	Feature	Local disk	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	2008 R2 to SQL Server 2012 or SQL Server 2016	✔️	❌	❌
Account management	Creation of a standard account or a privileged account	✔️	✔️	✔️
	Creation of a system admin account	✔️	✔️	✔️
	Host account creation for logons	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️
	Service account authorization	✔️	❌	❌
	Account deletion	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️
	Database attribute management	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️
	Endpoint and port number 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	✔️	✔️	✔️
	TDE configuration	✔️	✔️	✔️
	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	✔️	✔️	✔️
Database restoration	Data restoration	✔️	✔️	✔️
Diagnosis and optimization	Autonomy service	✔️	❌	❌
Tag management	Tag creation	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️

Sales Support

Technical Support

Connect & Report Abuse

About Alibaba Cloud

Our Global Network

Quick Start

Global Offices

Olympic Games Paris 2024 New

Stade Roland Garros – Glitz from the Past New

Place de la Concorde – “Breaking” the Barriers New

Vaires-sur-Marne Nautical Stadium – Sports with Sustainability New

International Broadcast Center – Images, Sounds, and Data that Captivate Billions New

Customer Success Stories New

Trust Center

Security & Compliance Center

Cloud Compliance Resources

Security Compliance FAQs

Product & Feature Update New

Cloud Forward

Press Room

Alibaba Cloud e-Magazine New

Alibaba Cloud in Analyst Research

Notice

Go Global Service New

Go Global Alliance with Alibaba Cloud

China Gateway Hot

Information Compliance

China Gateway - MLPS 2.0 Compliance New

China Gateway - Networking

China Gateway - Global Application Acceleration New

China Gateway - Security

China Gateway - Data Security New

ICP Support Hot

China Gateway - Omnichannel Data Mid-End New

China Gateway - Organizational Data Mid-End New

China Gateway - Business Mid-End New

China Gateway - AI Service for Conversational Chatbots New

China Gateway - Online Education

China Gateway - Domain Registration

Work at Alibaba Cloud

Experienced Professionals

Students and Graduates

Free Trial

Pricing

Promo Center

Price Reduction

Pay Less and Deploy More

FinOps

Elastic Compute Service (ECS)

Simple Application Server (SAS)

Elastic GPU Service

Elastic Desktop Service (EDS)

Object Storage Service (OSS)

Cloud Enterprise Network (CEN)

Web Application Firewall (WAF)

Domain Names

Container Compute Service (ACS)

Secure Access Service Edge (SASE)

Intelligent Media Services(IMS)

Edge Security Acceleration (ESA)(Original DCDN)

Intelligent Media Management

DingTalk Enterprise

YiDA

Alibaba Cloud Model Studio

Apsara Prime - For Easy Cloud Product Selection

Alibaba Cloud ECS - Cater All Your Cloud Hosting Needs

1TB CDN—Get Free 1 TB Outbound Traffic Plan Now

Security—Under Attack? Get Free Security Support

Short Message Service - Free Testing is Available

Elastic Compute Service (ECS) Hot

CloudBox

Compute Nest

Dedicated Host Hot

ECS Bare Metal Instance

Elastic Desktop Service (EDS) Featured

Elastic GPU Service Featured

Simple Application Server (SAS) Hot

Auto Scaling

Cloud Phone Beta

Elastic Desktop Service (EDS) Featured

Batch Compute

Elastic High Performance Computing (E-HPC)

Super Computing Cluster (SCC)