Compare NULL and blank as equal

karen

I have SQL Data Compare 7.1.0.245.

I am comparing the data in two databases, and because of the way data is loaded from one to the other, a NULL field in the first ends up as blank in the second.

That difference is ok for me. How do I change the settings so that difference is ignored? Because of that, I can't pick out the true differences in the data.

Brian Donahue

Hi Karen,

Unfortunately, you cannot get SQL Data Compare to consider <NULL> as equal to an empty string of characters, zero, or any other value that could be considered an empty value. I had tried setting the trim trailing spaces option, but SDC still shows a difference in that row between <NULL> and empty.

All I can think of is to go into the object mapping and exclude the column entirely, which may not be the best idea.

karen

Well, at least I know I wasn't overlooking a setting. I may exclude each column as I check them, so that other differences eventually do stand out.

Thank you.