Compare NULL and blank as equal
karen
Posts: 3
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.
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.
Comments
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.
Thank you.