Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com> Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
12 KiB
Microsoft SQL Server Constraints
RDS for SQL Server only supports DB instances under the License Included model and does not support "bring your own license" (BYOL). After a DB instance is created, it contains the Microsoft SQL Server software license.
Table 1 shows the constraints designed to ensure the stability and security of RDS for SQL Server.
Microsoft SQL Server DB instances are classified into three types: single, primary/standby, and cluster. Different types support different functions. For details, see Function Comparison.
Function Item |
Single |
Primary/Standby |
---|---|---|
Maximum number of databases |
100 |
100 |
Number of database accounts |
Unlimited |
Unlimited |
Creation of user, LOGIN, or database |
Supported |
Supported |
Database-level DDL trigger |
Supported |
Supported |
Database permission authorization |
Supported |
Supported |
KILL permission |
Supported |
Supported |
Distributed transaction |
Supported |
Supported |
SQL Profiler |
Supported |
Supported |
Tuning Adviser |
Supported |
Supported |
Change Data Capture (CDC) |
Supported |
Supported |
Change tracking |
Supported |
Supported |
Windows domain account login |
Supported |
Supported |
Not supported |
Not supported |
|
SQL Server Integration Services (SSIS) |
Not supported |
Not supported |
SQL Server Analysis Services (SSAS) |
Not supported |
Not supported |
SQL Server Reporting Services (SSRS) |
Not supported |
Not supported |
R Services |
Not supported |
Not supported |
Common Language Runtime (CLR) |
Not supported |
Not supported |
Asynchronous communication |
Not supported |
Not supported |
Replication subscription |
Not supported |
Not supported |
Policy management |
Not supported |
Not supported |