- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Best Practice
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Instance Management APIs
- CreateCloudDBInstances
- CreateCloudReadOnlyDBInstances
- ModifyInstanceEncryptAttributes
- UpgradeDBInstance
- RollbackInstance
- RestoreInstance
- RestartDBInstance
- ResetAccountPassword
- ModifyDBRemark
- ModifyDBName
- ModifyDBInstanceProject
- ModifyDBInstanceName
- ModifyAccountPrivilege
- InquiryPriceUpgradeDBInstance
- InquiryPriceCreateDBInstances
- DescribeZones
- DescribeRollbackTime
- DescribeRegions
- DescribeProductConfig
- DescribeFlowStatus
- DescribeDBs
- DescribeDBInstances
- DescribeAccounts
- DeleteDB
- DeleteAccount
- CreateDBInstances
- CreateDB
- CreateAccount
- TerminateDBInstance
- RecycleDBInstance
- CloneDB
- DescribeDBCharsets
- ModifyDatabaseMdf
- ModifyDatabaseCT
- ModifyDatabaseCDC
- DescribeDBsNormal
- ModifyInstanceParam
- DescribeInstanceParams
- DescribeInstanceParamRecords
- OpenInterCommunication
- DescribeDBInstanceInter
- DescribeBusinessIntelligenceFile
- DeleteBusinessIntelligenceFile
- CreateBusinessIntelligenceFile
- CreateBusinessDBInstances
- CloseInterCommunication
- Network Management APIs
- Backup APIs
- RunMigration
- ModifyMigration
- DescribeMigrations
- DescribeMigrationDetail
- DescribeBackups
- DeleteMigration
- CreateMigration
- CreateBackup
- ModifyBackupStrategy
- StartIncrementalMigration
- StartBackupMigration
- ModifyIncrementalMigration
- ModifyBackupMigration
- DescribeUploadBackupInfo
- DescribeIncrementalMigration
- DescribeBackupUploadSize
- DescribeBackupMigration
- DescribeBackupCommand
- DeleteIncrementalMigration
- DeleteBackupMigration
- CreateIncrementalMigration
- CreateBackupMigration
- DescribeBackupFiles
- Extended Event APIs
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Best Practice
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Instance Management APIs
- CreateCloudDBInstances
- CreateCloudReadOnlyDBInstances
- ModifyInstanceEncryptAttributes
- UpgradeDBInstance
- RollbackInstance
- RestoreInstance
- RestartDBInstance
- ResetAccountPassword
- ModifyDBRemark
- ModifyDBName
- ModifyDBInstanceProject
- ModifyDBInstanceName
- ModifyAccountPrivilege
- InquiryPriceUpgradeDBInstance
- InquiryPriceCreateDBInstances
- DescribeZones
- DescribeRollbackTime
- DescribeRegions
- DescribeProductConfig
- DescribeFlowStatus
- DescribeDBs
- DescribeDBInstances
- DescribeAccounts
- DeleteDB
- DeleteAccount
- CreateDBInstances
- CreateDB
- CreateAccount
- TerminateDBInstance
- RecycleDBInstance
- CloneDB
- DescribeDBCharsets
- ModifyDatabaseMdf
- ModifyDatabaseCT
- ModifyDatabaseCDC
- DescribeDBsNormal
- ModifyInstanceParam
- DescribeInstanceParams
- DescribeInstanceParamRecords
- OpenInterCommunication
- DescribeDBInstanceInter
- DescribeBusinessIntelligenceFile
- DeleteBusinessIntelligenceFile
- CreateBusinessIntelligenceFile
- CreateBusinessDBInstances
- CloseInterCommunication
- Network Management APIs
- Backup APIs
- RunMigration
- ModifyMigration
- DescribeMigrations
- DescribeMigrationDetail
- DescribeBackups
- DeleteMigration
- CreateMigration
- CreateBackup
- ModifyBackupStrategy
- StartIncrementalMigration
- StartBackupMigration
- ModifyIncrementalMigration
- ModifyBackupMigration
- DescribeUploadBackupInfo
- DescribeIncrementalMigration
- DescribeBackupUploadSize
- DescribeBackupMigration
- DescribeBackupCommand
- DeleteIncrementalMigration
- DeleteBackupMigration
- CreateIncrementalMigration
- CreateBackupMigration
- DescribeBackupFiles
- Extended Event APIs
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
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 | - | 2008 R2 Enterprise
2012 Standard/Enterprise
2014 Standard/Enterprise
2016 Standard/Enterprise
2017 Standard/Enterprise
2019 Standard/Enterprise 2022 Enterprise | 2008 R2 Enterprise
2012 Enterprise
2014 Enterprise
2016 Enterprise
2017 Enterprise
2019 Enterprise 2022 Enterprise |
Lifecycle | Instance creation | Supported | Supported |
| | | Instance restart |
| | | Auto-renewal |
| | | Billing mode modification |
| | | 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 |
| | | 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 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 |
| | | Increment 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 |
| | | Rollback to current instance |
| | | Rollback to existing intra-region instance |
| | | Rollback to existing cross-region instance |
| | | 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 | Supported |
| | 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 |
| | | Privileged account |
| | | Designated account |
| Admin Account | Unsupported | Supported |
Database management | Database creation | Supported | Supported |
| | | Database deletion |
| | | Database cloning |
| | | Database authorization |
| | | Change data capture (CDC) |
| | | Change tracking (CT) |
| | | Database shrinking |
Data security | Security group | Supported | Supported |
| Database audit | Unsupported currently | Unsupported |
| | | Network encryption |
| | TDE | Supported |
Data channel | Data sync | Unsupported currently | Unsupported currently |
| Homogeneous data migration | Supported | Supported |
| Heterogeneous data migration | Unsupported | Unsupported |
| | Publish/Subscribe | 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 template | Unsupported | Unsupported |
Performance optimization | Expert service | Supported | Supported |
| Resource analysis | Unsupported | Unsupported |
| | | Engine analysis |
Network | Classic network | Supported | Supported |
| | | VPC |
| Public network address | Supported | Supported |
Yes
No
Was this page helpful?