Features and Differences
Last updated: 2025-08-07 16:50:20
This document describes the features and differences of TencentDB for SQL Server editions.
Edition Features and Differences
Note：
In the following table, "-" means not involved.
Module | Feature | Single-Node (Formerly Basic Edition) | Dual-Node (Formerly HA Edition and Cluster Edition) | Multi-Node |
Version | - | 2008R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise 2022 Enterprise | 2008R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise 2022 Enterprise | 2017 Enterprise 2019 Enterprise 2022 Enterprise |
Lifecycle | Instance creation | Supported | Supported | Supported |
| Instance restart | Supported | Supported | Supported |
| Automatic renewal | Supported | Supported | Supported |
| Billing mode change | Supported | Supported | Supported |
| Instance termination | Supported | Supported | Supported |
| Read-only instance creation | Not supported | Supported | Supported (enable the feature via the read-only capability of the secondary node) |
| Specification adjustment | Supported | Supported | Supported |
| Disk scaling | Scale-out: Supported. Scale-in: Not supported. | Local disk scaling: Supported. Cloud disk scale-out: Supported. Cloud disk scale-in: Not supported. | Scale-out: Supported. Scale-in: Not supported. |
| Version upgrade | Supported | Supported | Supported |
| Architecture upgrade | Not supported | Supported | - |
Instance attribute | View of instance list | Supported | Supported | Supported |
| View of instance details | | | |
| Instance name modification | | | |
| Instance remark modification | | | |
| Instance tag settings | | | |
| Maintenance time management | | | |
| Project management | | | |
Service availability | Highly available method | Compute node migration + disk snapshot | SQL Server 2008R2/2012/2014/2016 Enterprise: Adopt the HA architecture with a mirror database For versions SQL Server 2017/2019/2022 Enterprise, the Always On HA is used. | Always On HA is used. |
| Cross-AZ disaster recovery | Not supported | Supported | Supported |
| Intra-city disaster recovery | Not supported | Supported | Supported |
| Read-only instance removal | Not supported | Supported | - |
| Cross-AZ migration | Not supported | Supported | Supported |
Backup and restoration | Full backup | Supported | Supported | Supported |
| Data backup | | | |
| Incremental backup | | | |
| Log backup | | | |
| Scheduled backup | | | |
| Manual backup | | | |
| Packaged backup | | | |
| Single-database backup | | | |
| Instance backup | | | |
| Multi-database backup | | | |
| Backup policy customization | | | |
| Recover by backup set | | | |
| Recover by time point | | | |
| Recover by user backup set | | | |
| Rollback to the current instance | | | |
| Rollback to an existing instance (intra-region) | | | |
| Rollback to an existing instance (cross-region) | | | |
| Backup download | | | |
| Perform backup tasks for a primary instance | Not supported | SQL Server 2008R2/2012/2014/2016 Enterprise: Not supported For versions SQL Server 2017/2019/2022 Enterprise, it is supported. | Not supported |
Monitoring and alarm | Resource monitoring | Supported | Supported | Supported |
| Engine monitoring | | | |
| Real-time monitoring | | | |
| Monitoring policy customization | | | |
| Alarm | | | |
Account management | Account creation and deletion | Supported | Supported | Supported |
| Password reset | | | |
| Database permission setup | | | |
| Table permission setup | | | |
| Ordinary account | | | |
| Advanced-permission account | | | |
| Special-permission account | | | |
| Super-permission account | Supported | Not supported | Not supported |
Database management | DMC data management | Supported | Supported | Supported |
| Database creation | | | |
| Database deletion | | | |
| Database cloning | | | |
| Database authorization | | | |
| Change data capture (CDC) | | | |
| Change tracking (CT) | | | |
| Database shrink | | | |
Data security | Security group | Supported | Supported | Supported |
| Database auditing | Not supported | Not supported | Not supported |
| Network encryption | | | |
| TDE encryption | Supported | Supported | Not supported |
| SSL encryption | Supported | Supported | Supported |
| Disk encryption | Supported for instances with cloud disks and SQL Server 2019/2022 Enterprise | Supported for instances with cloud disks and SQL Server 2019/2022 Enterprise | Supported for instances with cloud disks and SQL Server 2019/2022 Enterprise |
Data channel | Data sync | Not supported | Not supported | Not supported |
| Homogeneous data migration | Supported | Supported | Supported |
| Heterogeneous data migration | Not supported | Not supported | Not supported |
| Publishing/subscription | | Supported | Not supported |
Log management | Error logs | Not supported | Not supported | Not supported |
| Slow logs | Supported | Supported | Supported |
| Run logs | Not supported | Not supported | Not supported |
| Blocking and deadlock events | For versions SQL Server 2012/2014/2016/2017/2019/2022 Enterprise, it is supported. | For versions SQL Server 2012/2014/2016/2017/2019/2022 Enterprise, it is supported. | Supported |
Parameter management | Parameter update | Supported | Supported | Supported |
| Parameter history | | | |
| Parameter template | Not supported | Not supported | Not supported |
Performance optimization | Expert service | Supported | Supported | Supported |
| Resource analysis | Not supported | Not supported | Not supported |
| Engine analysis | | | |
Network | Virtual Private Cloud | Supported | Supported | Supported |
| Public network address | Supported | Supported | Supported |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback