SQL Server Use Database Compatibility Level Setting

documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare SQL Server Namespace/SQL Server Behavior Options Namespace/SQL Server Use Database Compatibility Level Setting.md

latest487 B

Original Source

Description

Uses a database's compatibility level instead of the SQL Server version.

Type

Boolean

Default

false

Usage

Flyway Desktop

This can be set from the comparison options settings in SQL Server projects.

Command-line

powershell

./flyway diff -redgateCompare.sqlserver.options.behavior.useDatabaseCompatibilityLevel=true

TOML Configuration File

toml

[redgateCompare.sqlserver.options.behavior]
useDatabaseCompatibilityLevel = true