This document describes the features and differences of TencentDB for SQL Server editions.
Module | Feature | Dual-Server High Availability Edition | Cluster Edition | Basic Edition |
2008 R2 Enterprise 2012 Standard/Enterprise 2014 Standard/Enterprise 2016 Standard/Enterprise 2017 Standard/Enterprise 2019 Standard/Enterprise |
2017 Enterprise 2019 Enterprise |
2008 R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise | ||
Lifecycle | Instance creation | Supported | Supported | Supported |
Instance restart | ||||
Billing mode change | ||||
Instance termination | ||||
Read-only instance creation | ||||
Publish/Subscribe | ||||
Specification upgrade/downgrade | ||||
Disk capacity adjustment | ||||
Version upgrade | ||||
Architecture upgrade | ||||
Instance attribute | Instance list view | Supported | Supported | Supported |
Instance details view | ||||
Instance renaming | ||||
Instance remarks modifying | ||||
Instance tagging | ||||
Maintenance time management | ||||
Project management | ||||
Service availability | High availability method | Mirror HA | Always On high availability | Compute node migration + disk snapshot |
Cross-AZ disaster recovery | Supported | Supported | Unsupported | |
Intra-region disaster recovery | Supported | Supported | Unsupported | |
Read-only instance removal | Supported | Supported | Unsupported | |
Cross-AZ migration | Supported | Supported | Unsupported | |
Backup and restoration | Full backup | Supported | Supported | Supported |
Data backup | ||||
Incremental backup | ||||
Log backup | ||||
Scheduled backup | ||||
Manual backup | ||||
Archive file | ||||
Unarchived files | ||||
Instance backup | ||||
Multi-database backup | ||||
Backup policy customization | ||||
Restoration by backup set | ||||
Restoration by time point | ||||
Restoration by user backup set | ||||
Backup download | ||||
Backup task execution on replica instance | Unsupported | Supported | Unsupported | |
Monitoring and alarms | Resource monitoring | Supported | Supported | Supported |
Engine monitoring | Supported | |||
Second-level monitoring | Unsupported (one-minute granularity) | |||
Monitoring policy customization | Unsupported | Unsupported | Supported | |
Alarm | Supported | Supported | Supported | |
Account management | Account creation and deletion | Supported | Supported | Supported |
Read/Write permission separation | ||||
Admin account | ||||
SA account | Unsupported | Unsupported | Supported | |
Database management | Database creation | Supported | Supported | Supported |
Database deletion | ||||
Database cloning | ||||
Database authorization | ||||
Change data capture (CDC) | ||||
Change tracking (CT) | ||||
Database shrinking | ||||
Data security | Security group | Supported | Supported | Supported |
Database audit | Unsupported currently | Unsupported currently | Unsupported | |
Network encryption | ||||
TDE encryption | Supported | Supported | ||
Data channel | Data sync | Unsupported currently | Unsupported currently | Unsupported currently |
Homogeneous data migration | Supported | Supported | Supported | |
Heterogeneous data migration | Unsupported | Unsupported | Unsupported | |
Publish/Subscribe | Supported | Supported | ||
Log management | Error log | Unsupported | Unsupported | Unsupported |
Slow log | Supported | Supported | Supported | |
Execution log | Unsupported | Unsupported | Unsupported | |
Parameter management | Parameter update | Supported | Supported | Supported |
Parameter history | ||||
Parameter template | Unsupported | Unsupported | Unsupported | |
Performance optimization | Expert service | Supported | Supported | Supported |
Resource analysis | Unsupported | Unsupported | Unsupported | |
Engine analysis | ||||
Network | Classic network | Supported | Supported | Supported |
VPC | ||||
Public address | Unsupported | Unsupported | Unsupported |
Was this page helpful?