ContextQMD
Back to Flyway

SQL Server Data Comparison Options Namespace

documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare SQL Server Namespace/SQL Server Data Comparison Options Namespace.md

latest2.8 KB
Original Source

{% include enterprise.html %}

This namespace contains the configurations relating to SQL Server static data comparison.

Settings

SettingTypeDescription
compressTemporaryFilesBooleanCompress the temporary files that are generated while performing the comparison.
forceBinaryCollationBooleanFor all string data types, forces binary collation irrespective of column collation, resulting in a case-sensitive comparison.
treatEmptyStringAsNullBooleanWhen this option is selected, empty strings (no characters) will be treated as NULL.
trimTrailingWhiteSpaceBooleanIf the data in two columns differs only by whitespace at the end of the string, the data will be considered to be identical.
useChecksumComparisonBooleanPerforms a checksum on each table prior to comparison.
useMaxPrecisionForFloatComparisonBooleanCompare floating point values to the maximum 17 digits of precision.