edit-icon download-icon

Function differences between SQL Server versions

Last Updated: Apr 12, 2018

RDS SQL Server instance functions depend on the instance version. Details are as follows:

Basic functions

ModuleFunctionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
Life cycleCreate an instanceSupportedSupportedSupported
Restart an instance
Automatic renewal
Change the billing method
Change specifications
Release an instance
Create a temporary instanceNot supportedSupportedSupported
Upgrade the engine versionComing soonComing soonComing soon
Clone an instanceComing soonNot supportedNot supported
Create a read-only instanceNot supportedNot supportedNot supported
Instance propertiesView the instance listSupportedSupportedSupported
View details about an instance
Modify the instance description
Set the maintenance time window
Manage instance labels
Migrate to another zoneNot supportedSupportedNot supported
Database connectionVPC addressSupportedSupportedSupported
Internet address
Read/Write splitting addressNot supportedNot supportedNot supported
Service availability
Disaster recovery in a zoneSupportedSupportedSupported
Cross-zone disaster recoverySupportedSupportedNot supported
Cross-region disaster recoveryNot supportedNot supportedNot supported
Disaster recovery drill
Backup and recoveryFull backupSupportedSupportedSupported
Incremental backup
Log backup
Customize backup policies
Recover by backup set
Recover by time
Recover from external backup filesComing soonSupported (full backup)Coming soon
Recover by creating a clone instanceComing soonNot supportedComing soon
Partial backupNot supportedNot supportedNot supported
Partial recovery
Monitoring and alarmsResource monitoringSupportedSupportedSupported
Engine monitoring
Customize monitoring
Aggregate monitoring items
Parameter managementParameter updateSupported (T-SQL)SupportedSupported (T-SQL)
Parameter template
Log managementError logsSupported (T-SQL)SupportedSupported (T-SQL)
System running logs

Data management functions

ModuleFunctionHigh-availability seriesBasic series
2016 Standard/Enterprise
2012 Standard/Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
Data managementManage usersSupported (T-SQL)SupportedSupported (T-SQL)
Manage databases and tablesSupported (T-SQL)
Operate table
Schedule a task
Data channelHomogeneous data migrationSupported with DTSSupported with DTSSupported with DTS
Heterogeneous data migration
Data synchronization
Data subscriptionNot supportedNot supportedNot supported
Data securityIP address whitelistSupportedSupportedSupported
Management audit
FirewallSupported (IP address whitelist)Supported (IP address whitelist)Supported (IP address whitelist)
Database auditComing soonSupportedComing soon
Storage encryptionNot supportedSupportedNot supported
Network encryptionNot supportedSupportedNot supported
Security group managementNot supportedNot supportedNot supported
Performance optimization
Expert serviceSupportedSupportedSupported
Resource analysisNot supportedNot supportedNot supported
Engine analysis
Engine/Code optimization

Official functions

Function differences between SQL Server Web, Standard, and Enterprise are as follows.

ItemWebStandardEnterprise
Specification16-core 64 GB24-core 128 GBNone
High availabilitySingle hostMirror HAAlwaysOn availability
Data compressionNot supportedSupportedSupported
SQL Profiler
Column index
Table/Index partitioningSupported by SQL Server 2016
Not supported by SQL Server 2012
CDC
Online DDLNot supported
Parallel searches
Adjust parallelism of partitioned tables
TDE
Integration of advanced R

Thank you! We've received your feedback.