Get‑SqlDscCompatibilityLevel - dsccommunity/SqlServerDsc GitHub Wiki

Gets the supported database compatibility levels for a SQL Server instance or version.

Get-SqlDscCompatibilityLevel -ServerObject <Server> [<CommonParameters>]

Get-SqlDscCompatibilityLevel -Version <Version> [<CommonParameters>]

This command returns the supported database compatibility levels for a SQL Server Database Engine instance or a specific SQL Server version.

The compatibility levels are determined based on the SQL Server version, following the official Microsoft documentation for supported compatibility level ranges.

$serverObject = Connect-SqlDscDatabaseEngine -InstanceName 'MyInstance'
Get-SqlDscCompatibilityLevel -ServerObject $serverObject

Returns all supported compatibility levels for the connected SQL Server instance.

$serverObject = Connect-SqlDscDatabaseEngine -InstanceName 'MyInstance'
$serverObject | Get-SqlDscCompatibilityLevel

Returns all supported compatibility levels using pipeline input.

Get-SqlDscCompatibilityLevel -Version '16.0.1000.6'

Returns all supported compatibility levels for SQL Server 2022 (version 16).

Specifies the SQL Server connection object to get supported compatibility levels for.

Type: Server
Parameter Sets: ServerObject
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

Specifies the SQL Server version to get supported compatibility levels for. Only the major version number is used for determining compatibility levels.

Type: Version
Parameter Sets: Version
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.