search

dataplat / docs

The documentation for dbatools module. Issues with command doc and bugs should be reported to dataplat/dbatools.
https://docs.dbatools.io
15 stars 12 forks source link

Set-DbaDbCompatibility does not Support SQL Server 2022 "Version160" yet #75

Closed KlugerSteffen closed 1 year ago

KlugerSteffen commented 1 year ago

Error Message: Set-DbaDbCompatibility : Cannot validate argument on parameter 'TargetCompatibility'. The argument "16" does not belong to the set "9,10,11,12,13,14,15" specified by the ValidateSet attribute. Supply an argument that is in the set and then try the command again. At line:1 char:117

Need to use SqlServer Module 22.0.30-preview to implement workaround: `$dbs = get-DbaDatabase -sqlInstance $instance -database $db

$dbs.Compatibility = "Version160"

$dbs.Alter() `

Further, get-dbaDbCompatibility returns Compatibility as 160 instead of "Version160".

KlugerSteffen commented 1 year ago

wrong place - not a documentation issue