Ignore column when viewing row differences
Sometimes when viewing row differences, you see a column with differences that appears to be unimportant. It would be nice that you can right-click on this column and have the possibility to ignore that column. In the current system, you have to go to 'Edit Project' -> tab Tables & views -> find the table -> alter 'Columns in Comparison' -> Click dropdown button to get a list of all columns of that table -> scroll to the column you want to leave out of the comparison -> deselect it -> recompare.
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:
https://documentation.red-gate.com/display/SDC12/SQL+Data+Compare+12.1+release+notes
Please let us know on the SQL Data Compare forums if you have any feedback about this feature:
-
Leandro Vasco commented
No, Andrew:
"When viewing row differences". "Sometimes when viewing row differences, you see a column with differences that appears to be unimportant". A column with differences.You said "option to hide columns having identical data in the source and target". They are not identical, they have differences.
I want to give 3 votes to this suggestion.