Suppress columns with identical data
Similar to the option to suppress identical rows, I'd like to suppress columns that are identical on both systems. Especially when comparing tables in a DW environment where we may have 10s-100s of columns I'd rather not scroll across the 100 columns that are identical in order to find the one columns where we have differences.
Our primary Data Compare application is to validate data changes in th DEV/QA system by comparing against the good PROD data. These comparisons typically involve large tables (100s of columns, millions of rows)
SQL Data Compare V12.1 adds an option to hide columns having identical data in the source and target. The feature is described in our release notes:
Please let us know on the SQL Data Compare forums if you have any feedback about this feature: