Run case-sensitive comparisons
The Ignore case option in Data Compare
The Data Compare allows ignoring case in symbols for non-key columns of the following data types: (N)CHAR, (N)VARCHAR, (N)VARCHAR(MAX), (N)TEXT, CLR.
Note
The Ignore case option can be applied to data which size does not exceed 5 Mb.
To run case-insensitive string comparison, make sure that the Ignore case option is enabled.
Ignore case in object names
If you want to compare objects whose names differ only by their case, select the Ignore case in object names option in the New Data Comparison Wizard when configuring the comparison process. This option allows ignoring case in object names (tables, schemas, and columns) when mapping. For example, sales.Customer will be mapped to sales.custoMer when the option is enabled.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo
If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?