Redgate Flyway

SQL Server Data Comparison Options Namespace

Flyway Enterprise

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.

Didn't find what you were looking for?