class SqlServerEngineVersion

Language	Type name
.NET	Amazon.CDK.AWS.RDS.SqlServerEngineVersion
Java	software.amazon.awscdk.services.rds.SqlServerEngineVersion
Python	aws_cdk.aws_rds.SqlServerEngineVersion
TypeScript (source)	@aws-cdk/aws-rds » SqlServerEngineVersion

The versions for the SQL Server instance engines (those returned by {@link DatabaseInstanceEngine.sqlServerSe}, {@link DatabaseInstanceEngine.sqlServerEx}, {@link DatabaseInstanceEngine.sqlServerWeb} and {@link DatabaseInstanceEngine.sqlServerEe}).

Example

declare const vpc: ec2.Vpc;

const parameterGroup = new rds.ParameterGroup(this, 'ParameterGroup', {
  engine: rds.DatabaseInstanceEngine.sqlServerEe({
    version: rds.SqlServerEngineVersion.VER_11,
  }),
  parameters: {
    locks: '100',
  },
});

new rds.DatabaseInstance(this, 'Database', {
  engine: rds.DatabaseInstanceEngine.SQL_SERVER_EE,
  vpc,
  parameterGroup,
});

Properties

Name	Type	Description
sqlServerFullVersion	string	The full version string, for example, "15.00.3049.1.v1".
sqlServerMajorVersion	string	The major version of the engine, for example, "15.00".
static VER_11	SqlServerEngineVersion	Version "11.00" (only a major version, without a specific minor version).
static VER_11_00_5058_0_V1	SqlServerEngineVersion	Version "11.00.5058.0.v1".
static VER_11_00_6020_0_V1	SqlServerEngineVersion	Version "11.00.6020.0.v1".
static VER_11_00_6594_0_V1	SqlServerEngineVersion	Version "11.00.6594.0.v1".
static VER_11_00_7462_6_V1	SqlServerEngineVersion	Version "11.00.7462.6.v1".
static VER_11_00_7493_4_V1	SqlServerEngineVersion	Version "11.00.7493.4.v1".
static VER_12	SqlServerEngineVersion	Version "12.00" (only a major version, without a specific minor version).
static VER_12_00_5000_0_V1	SqlServerEngineVersion	Version "12.00.5000.0.v1".
static VER_12_00_5546_0_V1	SqlServerEngineVersion	Version "12.00.5546.0.v1".
static VER_12_00_5571_0_V1	SqlServerEngineVersion	Version "12.00.5571.0.v1".
static VER_12_00_6293_0_V1	SqlServerEngineVersion	Version "12.00.6293.0.v1".
static VER_12_00_6329_1_V1	SqlServerEngineVersion	Version "12.00.6329.1.v1".
static VER_13	SqlServerEngineVersion	Version "13.00" (only a major version, without a specific minor version).
static VER_13_00_2164_0_V1	SqlServerEngineVersion	Version "13.00.2164.0.v1".
static VER_13_00_4422_0_V1	SqlServerEngineVersion	Version "13.00.4422.0.v1".
static VER_13_00_4451_0_V1	SqlServerEngineVersion	Version "13.00.4451.0.v1".
static VER_13_00_4466_4_V1	SqlServerEngineVersion	Version "13.00.4466.4.v1".
static VER_13_00_4522_0_V1	SqlServerEngineVersion	Version "13.00.4522.0.v1".
static VER_13_00_5216_0_V1	SqlServerEngineVersion	Version "13.00.5216.0.v1".
static VER_13_00_5292_0_V1	SqlServerEngineVersion	Version "13.00.5292.0.v1".
static VER_13_00_5366_0_V1	SqlServerEngineVersion	Version "13.00.5366.0.v1".
static VER_13_00_5426_0_V1	SqlServerEngineVersion	Version "13.00.5426.0.v1".
static VER_13_00_5598_27_V1	SqlServerEngineVersion	Version "13.00.5598.27.v1".
static VER_13_00_5820_21_V1	SqlServerEngineVersion	Version "13.00.5820.21.v1".
static VER_13_00_5850_14_V1	SqlServerEngineVersion	Version "13.00.5850.14.v1".
static VER_13_00_5882_1_V1	SqlServerEngineVersion	Version "13.00.5882.1.v1".
static VER_14	SqlServerEngineVersion	Version "14.00" (only a major version, without a specific minor version).
static VER_14_00_1000_169_V1	SqlServerEngineVersion	Version "14.00.1000.169.v1".
static VER_14_00_3015_40_V1	SqlServerEngineVersion	Version "14.00.3015.40.v1".
static VER_14_00_3035_2_V1	SqlServerEngineVersion	Version "14.00.3035.2.v1".
static VER_14_00_3049_1_V1	SqlServerEngineVersion	Version "14.00.3049.1.v1".
static VER_14_00_3192_2_V1⚠️	SqlServerEngineVersion	Version "14.00.3192.2.v1".
static VER_14_00_3223_3_V1	SqlServerEngineVersion	Version "14.00.3223.3.v1".
static VER_14_00_3281_6_V1	SqlServerEngineVersion	Version "14.00.3281.6.v1".
static VER_14_00_3294_2_V1	SqlServerEngineVersion	Version "14.00.3294.2.v1".
static VER_14_00_3356_20_V1	SqlServerEngineVersion	Version "14.00.3356.20.v1".
static VER_14_00_3381_3_V1	SqlServerEngineVersion	Version "14.00.3381.3.v1".
static VER_15	SqlServerEngineVersion	Version "15.00" (only a major version, without a specific minor version).
static VER_15_00_4043_16_V1	SqlServerEngineVersion	Version "15.00.4043.16.v1".
static VER_15_00_4043_23_V1⚠️	SqlServerEngineVersion	Version "15.00.4043.23.v1".
static VER_15_00_4073_23_V1	SqlServerEngineVersion	Version "15.00.4073.23.v1".

---

sqlServerFullVersion

Type: string

The full version string, for example, "15.00.3049.1.v1".

---

sqlServerMajorVersion

Type: string

The major version of the engine, for example, "15.00".

---

static VER_11

Type: SqlServerEngineVersion

Version "11.00" (only a major version, without a specific minor version).

---

static VER_11_00_5058_0_V1

Type: SqlServerEngineVersion

Version "11.00.5058.0.v1".

---

static VER_11_00_6020_0_V1

Type: SqlServerEngineVersion

Version "11.00.6020.0.v1".

---

static VER_11_00_6594_0_V1

Type: SqlServerEngineVersion

Version "11.00.6594.0.v1".

---

static VER_11_00_7462_6_V1

Type: SqlServerEngineVersion

Version "11.00.7462.6.v1".

---

static VER_11_00_7493_4_V1

Type: SqlServerEngineVersion

Version "11.00.7493.4.v1".

---

static VER_12

Type: SqlServerEngineVersion

Version "12.00" (only a major version, without a specific minor version).

---

static VER_12_00_5000_0_V1

Type: SqlServerEngineVersion

Version "12.00.5000.0.v1".

---

static VER_12_00_5546_0_V1

Type: SqlServerEngineVersion

Version "12.00.5546.0.v1".

---

static VER_12_00_5571_0_V1

Type: SqlServerEngineVersion

Version "12.00.5571.0.v1".

---

static VER_12_00_6293_0_V1

Type: SqlServerEngineVersion

Version "12.00.6293.0.v1".

---

static VER_12_00_6329_1_V1

Type: SqlServerEngineVersion

Version "12.00.6329.1.v1".

---

static VER_13

Type: SqlServerEngineVersion

Version "13.00" (only a major version, without a specific minor version).

---

static VER_13_00_2164_0_V1

Type: SqlServerEngineVersion

Version "13.00.2164.0.v1".

---

static VER_13_00_4422_0_V1

Type: SqlServerEngineVersion

Version "13.00.4422.0.v1".

---

static VER_13_00_4451_0_V1

Type: SqlServerEngineVersion

Version "13.00.4451.0.v1".

---

static VER_13_00_4466_4_V1

Type: SqlServerEngineVersion

Version "13.00.4466.4.v1".

---

static VER_13_00_4522_0_V1

Type: SqlServerEngineVersion

Version "13.00.4522.0.v1".

---

static VER_13_00_5216_0_V1

Type: SqlServerEngineVersion

Version "13.00.5216.0.v1".

---

static VER_13_00_5292_0_V1

Type: SqlServerEngineVersion

Version "13.00.5292.0.v1".

---

static VER_13_00_5366_0_V1

Type: SqlServerEngineVersion

Version "13.00.5366.0.v1".

---

static VER_13_00_5426_0_V1

Type: SqlServerEngineVersion

Version "13.00.5426.0.v1".

---

static VER_13_00_5598_27_V1

Type: SqlServerEngineVersion

Version "13.00.5598.27.v1".

---

static VER_13_00_5820_21_V1

Type: SqlServerEngineVersion

Version "13.00.5820.21.v1".

---

static VER_13_00_5850_14_V1

Type: SqlServerEngineVersion

Version "13.00.5850.14.v1".

---

static VER_13_00_5882_1_V1

Type: SqlServerEngineVersion

Version "13.00.5882.1.v1".

---

static VER_14

Type: SqlServerEngineVersion

Version "14.00" (only a major version, without a specific minor version).

---

static VER_14_00_1000_169_V1

Type: SqlServerEngineVersion

Version "14.00.1000.169.v1".

---

static VER_14_00_3015_40_V1

Type: SqlServerEngineVersion

Version "14.00.3015.40.v1".

---

static VER_14_00_3035_2_V1

Type: SqlServerEngineVersion

Version "14.00.3035.2.v1".

---

static VER_14_00_3049_1_V1

Type: SqlServerEngineVersion

Version "14.00.3049.1.v1".

---

static VER_14_00_3192_2_V1⚠️

⚠️ Deprecated: SQL Server version 14.00.3192.2.v1 reached end of life

Type: SqlServerEngineVersion

Version "14.00.3192.2.v1".

---

static VER_14_00_3223_3_V1

Type: SqlServerEngineVersion

Version "14.00.3223.3.v1".

---

static VER_14_00_3281_6_V1

Type: SqlServerEngineVersion

Version "14.00.3281.6.v1".

---

static VER_14_00_3294_2_V1

Type: SqlServerEngineVersion

Version "14.00.3294.2.v1".

---

static VER_14_00_3356_20_V1

Type: SqlServerEngineVersion

Version "14.00.3356.20.v1".

---

static VER_14_00_3381_3_V1

Type: SqlServerEngineVersion

Version "14.00.3381.3.v1".

---

static VER_15

Type: SqlServerEngineVersion

Version "15.00" (only a major version, without a specific minor version).

---

static VER_15_00_4043_16_V1

Type: SqlServerEngineVersion

Version "15.00.4043.16.v1".

---

static VER_15_00_4043_23_V1⚠️

⚠️ Deprecated: This version is erroneous. You might be looking for {@link SqlServerEngineVersion.VER_15_00_4073_23_V1}, instead.

Type: SqlServerEngineVersion

Version "15.00.4043.23.v1".

---

static VER_15_00_4073_23_V1

Type: SqlServerEngineVersion

Version "15.00.4073.23.v1".

Methods

Name	Description
static of(sqlServerFullVersion, sqlServerMajorVersion)	Create a new SqlServerEngineVersion with an arbitrary version.

---

static of(sqlServerFullVersion, sqlServerMajorVersion)

public static of(sqlServerFullVersion: string, sqlServerMajorVersion: string): SqlServerEngineVersion

Parameters

• sqlServerFullVersion string — the full version string, for example "15.00.3049.1.v1".
• sqlServerMajorVersion string — the major version of the engine, for example "15.00".

Returns

• SqlServerEngineVersion

Create a new SqlServerEngineVersion with an arbitrary version.