Missing/Additional records show negative value

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi Sean,

I believe you're looking at the possibility that your indexes need to
be re-created. Please let me know if that works.

Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

+44 870 1600 037

mailto:[email protected]



"Sean Sampey" <[email protected]> wrote in message
news:[email protected]
> One more tidbit: the number of records in the '=' column exceeds the
number
> of records in the actual tables. Something's screwy...
>
> "Sean Sampey" <[email protected]> wrote in message
> news:[email protected]
> > Doing a compare on two databases, and I'm getting a negative value for
> > several tables for missing/additional records columns. There's no data
> > showing there. What gives? Enclosed is a screen capture.
> >
> >
> >
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello again Sean,

    SQL Data Compare makes the assumption that the database schema is
    identical on both sides. Trying to compare without identical schema can
    yield unpredictable results. You can always check your table's structure
    with SQL Compare!

    Brian Donahue

    Technical Support Engineer

    Red Gate Software Ltd.

    +44 870 1600 037

    mailto:[email protected]


    "Sean Sampey" <[email protected]> wrote in message
    news:[email protected]
    > The issue was that table A had indexes, table B did not. Duplicate data
    was
    > inserted into table B. Shouldn't Data Compare make sure both tables have
    > identical indices?
    >
    > Sean Sampey
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Sean,
    > >
    > > I believe you're looking at the possibility that your indexes need
    to
    > > be re-created. Please let me know if that works.
    > >
    > > Brian Donahue
    > >
    > > Technical Support Engineer
    > >
    > > Red Gate Software Ltd.
    > >
    > > +44 870 1600 037
    > >
    > > mailto:[email protected]
    > >
    > >
    > >
    > > "Sean Sampey" <[email protected]> wrote in message
    > > news:[email protected]
    > > > One more tidbit: the number of records in the '=' column exceeds the
    > > number
    > > > of records in the actual tables. Something's screwy...
    > > >
    > > > "Sean Sampey" <[email protected]> wrote in message
    > > > news:[email protected]
    > > > > Doing a compare on two databases, and I'm getting a negative value
    for
    > > > > several tables for missing/additional records columns. There's no
    > data
    > > > > showing there. What gives? Enclosed is a screen capture.
    > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.