All Products
Search
Document Center

ApsaraDB RDS:Features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions

Last Updated:Oct 31, 2023

This topic describes the features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions.

Basic features

Category

Feature

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

SQL Server 2022 EE on RDS Cluster Edition

SQL Server 2019 EE on RDS Cluster Edition

SQL Server 2017 EE on RDS Cluster Edition

SQL Server 2022 SE

SQL Server 2019 SE

SQL Server 2017 SE

SQL Server 2016 SE and SQL Server 2016 EE

SQL Server 2012 SE and SQL Server 2012 EE

SQL Server 2008 R2

SQL Server 2022 Web

SQL Server 2019 Web

2017 Web

SQL Server 2016 Web and SQL Server 2016 EE

SQL Server 2014 SE

SQL Server 2012 Web and SQL Server 2012 EE Basic

Lifecycle

Instance creation

Supported

Supported

Supported

Supported

Instance restart

Auto-renewal

Billing method change

Specification change

Instance release

Temporary instance creation

Not supported

Not supported

Supported

Supported

Upgrade of the database engine version

Supported

Supported

Supported

Supported

Instance cloning

Supported

Supported

Not supported

Supported

Read-only instance creation

Supported

Not supported

Not supported

Not supported

Instance properties

Viewing of instances

Supported

Supported

Supported

Supported

Viewing of instance details

Description modification

Maintenance window configuration

Tag management

Zone management

Not supported

Not supported

Supported

Not supported

Database connection

Virtual private cloud (VPC) endpoint

Supported

Supported

Supported

Supported

Public endpoint

Read/write splitting endpoint

Not supported

Not supported

Not supported

Not supported

Service availability

Disaster recovery inside a zone

Supported

Supported

Supported

Supported

Cross-zone disaster recovery

Supported

Supported

Supported

Not supported

Geo-disaster recovery

Not supported

Not supported

Not supported

Not supported

Disaster recovery drill

Backup and restoration

Full data backup

Supported

Supported

Supported

Supported

Incremental backup

Log backup

Backup policy customization

Restoration by backup set

Restoration by point in time

Restoration by user backup set

Supported (full backup, differential backup, and log backup)

Supported (full backup, differential backup, and log backup)

Supported (full backup)

Supported (full backup, differential backup, and log backup)

Restoration by using a cloned instance

Supported

Supported

Not supported

Supported

Backup of individual databases and tables

Supported

Supported

Not supported

Supported

Restoration of individual databases and tables

Monitoring and alerting

Resource monitoring

Supported

Supported

Supported

Supported

Engine monitoring

Monitoring policy customization

Monitoring aggregation

Parameter management

Parameter update

Supported (T-SQL)

Supported (T-SQL)

Supported

Supported (T-SQL)

Parameter template

Log management

Error logs

Supported (T-SQL)

Supported (T-SQL)

Supported

Supported (T-SQL)

Data management features

Category

Feature

RDS Cluster Edition

RDS High-availability Edition

RDS Basic Edition

SQL Server 2022 EE on RDS Cluster Edition

SQL Server 2019 EE on RDS Cluster Edition

SQL Server 2017 EE on RDS Cluster Edition

SQL Server 2022 SE

SQL Server 2019 SE

SQL Server 2017 SE

SQL Server 2016 SE and SQL Server 2016 EE

SQL Server 2012 SE and SQL Server 2012 EE

SQL Server 2008 R2

SQL Server 2022 Web

SQL Server 2019 Web

2017 Web

SQL Server 2016 Web and SQL Server 2016 EE

SQL Server 2014 SE

SQL Server 2012 Web and SQL Server 2012 EE Basic

Data management

User management

Supported

Supported

Supported

Supported

Database and table management

Supported

Supported

Supported

Supported

Data operation

Supported (only T-SQL)

Supported (only T-SQL)

Supported (only T-SQL)

Supported (only T-SQL)

Scheduled task

Supported (only T-SQL)

Supported (only T-SQL)

Supported (only T-SQL)

Supported (only T-SQL)

SQL Server Integration Services (SSIS)

Supported

(Shared instance types are not supported.)

Supported

(Shared instance types are not supported.)

Not supported

Supported

(Shared instance types are not supported.)

SQL Server Analysis Services (SSAS)

SQL Server Reporting Services (SSRS)

Data migration and synchronization

Homogeneous data migration

Supported (DTS)

Supported (DTS)

Supported (DTS)

Supported (DTS)

(DTS is not supported for SQL Server Web.)

Heterogeneous data migration

Data synchronization

Change tracking

Not supported

Not supported

Not supported

Not supported

Database replication between RDS instances

Supported

Supported

Not supported

Supported

Data security

IP address whitelist

Supported

Supported

Supported

Supported

Management and operation audit

Firewall

Supported

(IP address whitelist)

Supported

(IP address whitelist)

Supported

(IP address whitelist)

Supported

(IP address whitelist)

Database audit

Supported

Supported

Supported

Supported

Cloud disk encryption

Supported

Supported

Not supported

Supported

Network encryption

Supported

Supported

Supported

Supported

Security group management

Not supported

Not supported

Not supported

Not supported

Performance improvement

Storage capacity management

Supported

Supported

Not supported

Supported

Performance insight

Supported

Supported

Not supported

Supported

Index-based analysis

Supported

Supported

Not supported

Supported

Deadlock analysis

Supported

Supported

Not supported

Supported

Slow query log analysis

Supported

Supported

Not supported

Supported

Monitoring dashboard

Supported

Supported

Not supported

Supported

Features provided by Microsoft SQL Server

The following table describes the features that are provided by Microsoft SQL Server Web, Microsoft SQL Server SE, and Microsoft SQL Server EE.

Feature

SQL Server SE

SQL Server Web

SQL Server EE

Specifications

24 cores and 128 GB

16 cores and 64 GB

Not supported

High availability (HA)

Mirror HA

Standalone

Always On HA

Data compression

The features are supported for SQL Server 2016 SE and later SQL Server SE.

Not supported

Supported

SQL Profiler

Change data capture (CDC)

Column-based index

Online DDL

Not supported

Parallel indexed operations

Parallelism adjustment of partitioned tables

TDE

Advanced R integration

Table and index partitioning

  • Supported by SQL Server 2016

  • Not supported by SQL Server 2012

Note

For more information about the differences between the official editions (Web Edition, Standard Edition, and Enterprise Edition) of SQL Server, see the following topics: