• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Getting Started with Microsoft SQL Server
  5. Function Differences Between Microsoft SQL Server Versions

Function Differences Between Microsoft SQL Server Versions

This section describes function differences between Microsoft SQL Server versions.

  • For details about differences of basic functions, see Table 1.
  • For details about product function differences, see Table 1.
  • For details about differences of database migration functions, see Table 2.
  • For details about differences of database security functions, see Table 3.
Table 1 Differences of basic functions

Module

Function Item

High-Availability Edition

Basic Edition

Life cycle

Create a DB instance

Supported

Supported

Reboot a DB instance

Supported

Supported

Auto-renewal

Supported

Supported

Change the billing mode

Supported

Supported

Change the instance class

Supported

Supported

Delete a DB instance

Supported

Supported

Upgrade the DB engine version

Not supported

Not supported

Restore to a new DB instance

Supported

Supported

Create a read replica

Not supported

Not supported

DB instance properties

View the DB instance list

Supported

Supported

View DB instance details

Supported

Supported

Modify the DB instance description

Supported

Supported

Change the maintenance window

Supported

Supported

Manage tags

Supported

Supported

Manage AZs

Not supported

Not supported

Database connection

Internal access through a VPC

Supported

Supported

Public accessibility

Supported

Supported

Read/write splitting address

Not supported

Not supported

Service availability

Disaster recovery in an AZ

Supported

Supported

Disaster recovery in the same city

Supported

Not supported

Remote disaster recovery

Not supported

Not supported

Disaster recovery drill

Not supported

Not supported

Backups and restorations

Full backup

Supported

Supported

Log backup

Supported

Supported

Customize a backup policy

Supported

Supported

Restore from automated backups

Supported

Supported

Point in time recovery

Supported

Supported

Partial backup

Coming soon

Coming soon

Partial restore

Supported

Supported

Monitoring and alarms

Resource monitoring

Supported

Supported

DB engine monitoring

Not supported

Not supported

Customize monitoring policies

Supported

Supported

Aggregate monitoring items

Supported

Supported

Parameter management

Parameter update

Supported

Supported

Parameter template

Supported

Supported

Log management

Error logs

Supported

Supported

System running logs

Supported

Supported

Table 2 Differences of database migration

Function Item

High-Availability Edition

Basic Edition

Homogeneous data migration

Supported

Supported

Heterogeneous data migration

Coming soon

Coming soon

Data synchronization

Supported

Supported

Table 3 Differences of database security

Function Item

High-Availability Edition

Basic Edition

IP address whitelist

Coming soon

Coming soon

Management audit

Supported

Supported

Firewall

Supported (DBSS)

Supported (DBSS)

Database audit

Supported (DBSS)

Supported (DBSS)

Storage encryption

Coming soon

Coming soon

Network encryption

Supported

Supported

Security group management

Supported

Supported

Transparent Data Encryption (TDE) encryption

Coming soon (enterprise edition)

Coming soon (enterprise edition)

Table 4 lists the major differences of the Microsoft SQL Server official editions.

For more information about function differences among Microsoft SQL Server 2014 official editions, see official documents.

Table 4 Functions between standard and enterprise editions

Function Item

Standard Edition

Enterprise edition

Instance class

16 vCPUs | 128 GB

N/A

High availability

Mirror HA

Always On availability

Data compression

Supported

Supported

SQL Profiler

Supported

Supported

Column index

Supported

Supported

Table/index partitioning

Supported by Microsoft SQL Server 2014

Supported

Change Data Capture (CDC)

Supported

Supported

Online DDL

Not supported

Supported

Parallel searches

Not supported

Supported

Adjustment of partitioned table parallelism

Not supported

Supported

TDE

Not supported

Supported

Integration of advanced R

Not supported

Supported