Compare NULL and blank as equal

karenkaren 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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • 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.
Sign In or Register to comment.