Querying the Features Supported by a Version (RDS for SQL Server)

Function

This API is used to query the features supported by an RDS for SQL Server version.

Before calling this API, learn how to authenticate it.
Before calling this API, learn about request header parameters.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.

If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
rds:instance:listFlavors	read	-	-	-	-

URI

URI format
GET /v3/{project_id}/major-version-feature

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A

**Table 2** Request parameters
Parameter	Mandatory	Type	Description
version	Yes	String	Definition SQL Server version. Constraints N/A Range Example: 2022_SE, 2022_EE, 2022_WEB Default Value N/A
single	Yes	Boolean	Definition Whether the instance is a single-node instance. Constraints N/A Range N/A Default Value N/A

Request

None

Example Request

Query the features supported by a single-node instance running SQL Server 2022 Standard Edition.

GET https://{Endpoint}/v3/54623db08b174c858ba779d2aa7923a3/major-version-feature?version=2022_SE&single=true

Response

Normal response

**Table 3** Parameters
Parameter	Type	Description
version	String	Definition Version name. Range Example: 2022_SE, 2022_EE, 2022_WEB
support_upgrade_version	Array of strings	Definition Versions that can be upgraded. Range Example: 2022_SE, 2022_EE, 2022_WEB
support_recover_version	Array of strings	Definition Versions that support backup and restoration. Range Example: 2022_SE, 2022_EE, 2022_WEB
support_file_stream	Boolean	Definition Whether FileStream is supported. Range true: FileStream is supported. false: FileStream is not supported.
support_tde	Boolean	Definition Whether Transparent Data Encryption (TDE) is supported. Range true: TDE is supported. false: TDE is not supported.
support_always_on	Boolean	Definition Whether Always On is supported. Range true: Always On is supported. false: Always On is not supported.
support_read_only	Boolean	Definition Whether read replicas are supported. Range true: Read replicas are supported. false: Read replicas are not supported.

Example normal response

{ 
   "version" : "2022_SE", 
   "support_upgrade_version" : [ "2022_EE" ], 
   "support_recover_version" : [ "2022_SE", "2022_EE" ], 
   "support_file_stream" : true, 
   "support_tde" : true, 
   "support_always_on" : false, 
   "support_read_only" : false 
 }