How can we help you today? How can we help you today?

Compare NULL and blank as equal

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.
karen
0

Comments

2 comments

Sort by
  • 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.
    Brian Donahue
    0
  • 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.
    karen
    0

Add comment

Please sign in to leave a comment.