SQL Server Data Comparison Options Namespace
Published 15 January 2025
This namespace contains the configurations relating to SQL Server static data comparison.
Settings
Setting | Type | Description |
---|---|---|
compressTemporaryFiles |
Boolean | Compress the temporary files that are generated while performing the comparison. |
forceBinaryCollation |
Boolean | For all string data types, forces binary collation irrespective of column collation, resulting in a case-sensitive comparison. |
treatEmptyStringAsNull |
Boolean | When this option is selected, empty strings (no characters) will be treated as NULL . |
trimTrailingWhiteSpace |
Boolean | If the data in two columns differs only by whitespace at the end of the string, the data will be considered to be identical. |
useChecksumComparison |
Boolean | Performs a checksum on each table prior to comparison. |
useMaxPrecisionForFloatComparison |
Boolean | Compare floating point values to the maximum 17 digits of precision. |