Missing/Additional records show negative value

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited February 18, 2003 5:17AM in SQL Data Compare Previous Versions
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:brian.donahue@red-gate.com



"Sean Sampey" <sampey@cdnet.cod.edu> wrote in message
news:LvBrADq0CHA.1640@server53...
> One more tidbit: the number of records in the '=' column exceeds the
number
> of records in the actual tables. Something's screwy...
>
> "Sean Sampey" <sampey@cdnet.cod.edu> wrote in message
> news:KHVpDxh0CHA.1640@server53...
> > 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.
> >
> >
> >
>
>
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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:brian.donahue@red-gate.com


    "Sean Sampey" <sampey@cdnet.cod.edu> wrote in message
    news:dYgNJ220CHA.1180@server53...
    > 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)" <brian.donahue@red-gate.com> wrote in message
    > news:cFLc3vr0CHA.1436@server53...
    > > 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:brian.donahue@red-gate.com
    > >
    > >
    > >
    > > "Sean Sampey" <sampey@cdnet.cod.edu> wrote in message
    > > news:LvBrADq0CHA.1640@server53...
    > > > One more tidbit: the number of records in the '=' column exceeds the
    > > number
    > > > of records in the actual tables. Something's screwy...
    > > >
    > > > "Sean Sampey" <sampey@cdnet.cod.edu> wrote in message
    > > > news:KHVpDxh0CHA.1640@server53...
    > > > > 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.
    > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
    · Share on Twitter
This discussion has been closed.