DifferencesSummary and ResultsStore disagree

RodarinRodarin Posts: 3
edited October 3, 2011 7:24AM in SQL Comparison SDK Previous Versions
I ran a comparison on the "same" table in two different databases, one of which has had a single column of a single record modified. The DifferencesSummary.DifferenceCount() method of the TableDifference returns 1, and the In1 member of the DifferencesSummary has a value of 1 (which seems incorrect, as I simply modified a row contained in both).

When I look at the ResultsStore member of the TableDifference, it reports a RowCount of 0, and calling GetReader() or GetReader(Row.RowType.In1) on that ResultsStore gives a RowCount of 0.

If the TableDifference.DifferencesSummary knows there is a difference, why can't I get it?
· Share on Twitter

Comments

  • RodarinRodarin Posts: 3
    Never fails that you find the answer to your own question after you have given up and asked the world for help. The ComparisonSession.CompareDatabases was called with SessionSettings.IncludeDifferentRecords only, hence the result. Odd, though, that the DifferencesSummary still lets me know about In1 and In2.
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    Glad to hear you worked it out- I'm not sure why the two would differ like that off the top of my head, but they are two different things of course. I also saw recently that some of the properties in the DifferencesSummary are marked as obsolete now, so that may also be something to do with it.

    Let us know if you have any further trouble though!
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.