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

Basic features

CategoryFeatureRDS Cluster EditionRDS High-availability EditionRDS Basic Edition

SQL Server 2019 EE

SQL Server 2017 EE

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 EE

SQL Server 2016 Web

SQL Server 2012 Web

SQL Server 2012 EE

LifecycleInstance creationSupportedSupportedSupportedSupported
Instance restart
Auto-renewal
Billing method change
Specifications change
Instance release
Temporary instance creationNot supportedNot supportedSupportedSupported
Upgrade of the database engine versionSupportedSupportedSupportedSupported
Instance cloningSupportedSupportedNot supportedSupported
Read-only instance creationSupportedNot supportedNot supportedNot supported
Instance propertiesViewing of instancesSupportedSupportedSupportedSupported
Viewing of the instance details
Description change
Maintenance window configuration
Tag management
Zone managementNot supportedNot supportedSupportedNot supported
Database connectionVirtual private cloud (VPC) endpointSupportedSupportedSupportedSupported
Public endpoint
Read/write splitting endpointNot supportedNot supportedNot supportedNot supported
Service availabilityDisaster recovery inside a zoneSupportedSupportedSupportedSupported
Cross-zone disaster recoverySupportedSupportedSupportedNot supported
Geo-disaster recoveryNot supportedNot supportedNot supportedNot supported
Disaster recovery drill
Backup and restorationFull backupSupportedSupportedSupportedSupported
Incremental backup
Log backup
Backup policy customization
Restoration by backup file
Restoration by point in time
Restoration by user backup fileSupported (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 instanceSupportedSupportedNot supportedAvailable soon
Backup of partial dataSupportedSupportedNot supportedNot supported
Restoration of of partial data
Monitoring and alertingResource monitoringSupportedSupportedSupportedSupported
Engine monitoring
Monitoring policy customization
Monitoring aggregation
Parameter managementParameter updateSupported (T-SQL)Supported (T-SQL)SupportedSupported (T-SQL)
Parameter template
Log managementError logsSupported (T-SQL)Supported (T-SQL)SupportedSupported (T-SQL)
Run logs

Data management features

CategoryFeatureRDS Cluster EditionRDS High-availability EditionRDS Basic Edition

SQL Server 2019 EE

SQL Server 2017 EE

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 EE

SQL Server 2016 Web

SQL Server 2012 Web

SQL Server 2012 EE

Data managementUser managementSupported (T-SQL)Supported (T-SQL)SupportedSupported (T-SQL)
Database and table managementSupported (T-SQL)
Data operation
Scheduled task
Data tunnelHomogeneous data migrationSupported (DTS)Supported (DTS)Supported (DTS)Supported (DTS)
Note DTS is not supported by the SQL Server Web edition.
Heterogeneous data migration
Data synchronization
Data subscriptionNot supportedNot supportedNot supportedNot supported
Database replication between RDS instancesSupportedSupportedNot supportedSupported
Data securityIP address whitelistSupportedSupportedSupportedSupported
Management and operation audit
FirewallSupported (IP address whitelist)Supported (IP address whitelist)Supported (IP address whitelist)Supported (IP address whitelist)
Database auditSupportedSupportedSupportedSupported
Storage encryptionNot supportedNot supportedSupportedNot supported
Network encryptionSupportedSupportedSupportedSupported
Security group managementNot supportedNot supportedNot supportedNot supported
Performance optimizationExpert serviceSupportedSupportedSupportedSupported
Resource analysisNot supportedNot supportedNot supportedNot supported
Engine analysis
Engine and code optimization

Features provided by Microsoft SQL Server

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

FeatureMicrosoft SQL Server Web EditionMicrosoft SQL Server SEMicrosoft SQL Server EE
Specifications16 cores and 64 GB of capacity24 cores and 128 GB of capacityNone
High availability (HA)StandaloneMirror HAAlways On HA
Data compressionNot supportedSupported
Note The CDC feature is supported for the Standard editions of SQL Server 2016 or later.
Supported
SQL Profiler
Change data capture (CDC)
Column-based index
Online DDLNot 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