Perform case-insensitive comparisons

The topic describes how to perform a case-insensitive data comparison by configuring the relevant options on the Options page of the New Data Comparison wizard during the setup.

Ignore case option

Under Comparison Options, select Ignore case to treat uppercase and lowercase characters as equivalent in non-key columns with the following data types: (N)CHAR, (N)VARCHAR, (N)VARCHAR(MAX), (N)TEXT, and CLR.

Note

The Ignore case option can be applied only to data whose size does not exceed 5 MB.

Ignore case in object names option

Under Auto Mapping, select Ignore case in object names to treat uppercase and lowercase characters as equivalent in object names, such as tables, views, schemas, and columns, during mapping. For example, sales.Customer will be mapped to sales.customer when this option is enabled.