TencentDB for SQL Server
- Release Notes and Announcements
- Announcements
- Product Introduction
- Product Architecture
- Instance Specifications
- Purchase Guide
- Product Pricing
- Getting Started
- Connecting to TencentDB for SQL Server Instance
- Operation Guide
- Maintaining Instance
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Access Management
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Backup
- Setting Automatic Backup
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Using DTS to Migrate Data
- Pre-Validation Failure Handling
- Data Migration (Legacy)
- Migrating Data from SQL Server Instance Purchased at Other Cloud Service Provider or Built In-house
- Practical Tutorial
- API Documentation
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Data migration (cold standby migration) related APIs
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- FAQs
- Service Agreement
- Performance Evaluation
Features and Differences
Last updated: 2024-12-24 14:15:55
This document describes the features and differences of TencentDB for SQL Server editions.
Edition Features and Differences
Module | Feature | Two-Node (Formerly High-Availability/Cluster Edition) | Single-Node (Formerly Basic Edition) |
Edition | - | 2008R2 Enterprise 2012 Standard/Enterprise 2014 Standard/Enterprise 2016 Standard/Enterprise 2017 Standard/Enterprise 2019 Standard/Enterprise 2022 Enterprise | 2008R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise 2022 Enterprise |
Lifecycle | Instance creation | Supported | Supported |
| Instance restart | Supported | Supported |
| Auto-renewal | Supported | Supported |
| Billing mode modification | Supported | Supported |
| Instance termination | Supported | Supported |
| Read-only instance creation | Supported | Unsupported |
| Publish/Subscribe | Supported | Supported |
| Specification upgrade/downgrade | Supported | Supported |
| Disk capacity adjustment | Local Disk Expansion and Contraction: Supported Cloud Disk Expansion: Supported Disk Shrinking: Unsupported | Expansion: Supported Shrink: Unsupported |
| Version upgrade | Supported | Supported |
| Architecture upgrade | Supported | Unsupported |
Instance attribute | Instance list view | Supported | Supported |
| | | Instance details view |
| | | Instance renaming |
| | | Instance remarks modifying |
| | | Instance tagging |
| | | Maintenance time management |
| | | Project management |
Application availability | High availability method | SQL Server 2008R2/2012/2014/2016 Enterprise, SQL Server 2012/2014/2016 Standard adopt Mirror HA SQL Server 2017/2019/2022 Enterprise adopt Always On high availability | Compute node migration + disk snapshot |
| Cross-AZ disaster recovery | Supported | Unsupported |
| Intra-region disaster recovery | Supported | Unsupported |
| Read-only instance removal | Supported | Unsupported |
| Cross-AZ migration | Supported | Unsupported |
Backup and recovery | Full backup | Supported | Supported |
| Data backup | | Data backup |
| Increment backup | | Increment backup |
| Log backup | | Log backup |
| Scheduled backup | | Scheduled backup |
| Manual backup | | Manual backup |
| Archive file | | Archive file |
| Unarchived files | | Unarchived files |
| Instance backup | | Instance backup |
| Multi-database backup | | Multi-database backup |
| Backup policy customization | | Backup policy customization |
| Restoration by backup set | | Restoration by backup set |
| Restoration by time point | | Restoration by time point |
| Restoration by user backup set | | Restoration by user backup set |
| Rollback to current instance | | Rollback to current instance |
| Rollback to existing intra-region instance | | Rollback to existing intra-region instance |
| Rollback to existing cross-region instance | | Rollback to existing cross-region instance |
| Backup download | | Backup download |
| Backup task execution on replica instance | SQL Server 2008R2/2012/2014/2016 Enterprise, SQL Server 2012/2014/2016 Standard unsupported SQL Server 2017/2019/2022 Enterprise supported | Unsupported |
Monitoring and alarms | Resource monitoring | Supported | Supported |
| Engine monitoring | Engine monitoring | Supported |
| Second-level monitoring | Second-level monitoring | Unsupported (one-minute granularity) |
| Monitoring policy customization | Unsupported | Supported |
| Alarm | Supported | Supported |
Account management | Account creation and deletion | Supported | Supported |
| Standard account | | Standard account |
| Privileged account | | Privileged account |
| Designated account | | Designated account |
| Admin Account | Unsupported | Supported |
Database management | Database creation | Supported | Supported |
| Database deletion | | Database deletion |
| Database cloning | | Database cloning |
| Database authorization | | Database authorization |
| Change data capture (CDC) | | Change data capture (CDC) |
| Change tracking (CT) | | Change tracking (CT) |
| Database shrinking | | Database shrinking |
Data security | Security group | Supported | Supported |
| Database audit | Unsupported currently | Unsupported |
| Network encryption | | Network encryption |
| TDE encryption | Supported | Supported |
| SSL encryption | Supported | Supported |
Data channel | Data sync | Unsupported currently | Unsupported currently |
| Homogeneous data migration | Supported | Supported |
| Heterogeneous data migration | Unsupported | Unsupported |
| Publish/Subscribe | Supported | Supported |
Log management | Error log | Unsupported | Unsupported |
| Slow log | Supported | Supported |
| Execution log | Unsupported | Unsupported |
| Blocking and deadlock events | SQL Server 2012/2014/2016/2017/2019/2022 Enterprise supported | SQL Server 2012/2014/2016/2017/2019/2022 Enterprise supported |
Parameter management | Parameter update | Supported | Supported |
| Parameter history | | Parameter history |
| Parameter template | Unsupported | Unsupported |
Performance optimization | Expert service | Supported | Supported |
| Resource analysis | Unsupported | Unsupported |
| Engine analysis | | Engine analysis |
Network | Classic network | Supported | Supported |
| VPC | | VPC |
| Public network address | Supported | Supported |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No