3.2 Compound Keys Still a Problem?

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

If one of the PKs are of the datatype 'smallint', you could be seeing a
bug in SQL Data Compare 3.2. Try doing a 'check for updates' and get version
3.3, which has a fix for the problem.

Please let me know if I'm wrong in any way.

Thanks,

Brian Donahue
Red Gate Technical Support

"Grant Fritchey" <[email protected]> wrote in message
news:[email protected]
> Hello,
>
> I know in the initial release of 3.0 that compound primary keys created
> problems in the tool. We've just run into a problem in 3.2 where a table
has
> a two column primary key defined. We're seeing three records that are
> missing between tables showing up as changes and three records that are
> changes showing up as inserts.
>
> The exact version is 3.2.0.178. Any help here, or is more detail needed?
>
> Thanks,
>
> Grant
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Grant,

    Great! Thanks for getting in touch...

    Brian Donahue

    "Grant Fritchey" <[email protected]> wrote in message
    news:wog0mk%[email protected]
    > Thanks,
    >
    > That does seem to have fixed the issue.
    >
    > Grant
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Grant,
    > >
    > > If one of the PKs are of the datatype 'smallint', you could be
    seeing
    > a
    > > bug in SQL Data Compare 3.2. Try doing a 'check for updates' and get
    > version
    > > 3.3, which has a fix for the problem.
    > >
    > > Please let me know if I'm wrong in any way.
    > >
    > > Thanks,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Grant Fritchey" <[email protected]> wrote in message
    > > news:[email protected]
    > > > Hello,
    > > >
    > > > I know in the initial release of 3.0 that compound primary keys
    created
    > > > problems in the tool. We've just run into a problem in 3.2 where a
    table
    > > has
    > > > a two column primary key defined. We're seeing three records that are
    > > > missing between tables showing up as changes and three records that
    are
    > > > changes showing up as inserts.
    > > >
    > > > The exact version is 3.2.0.178. Any help here, or is more detail
    needed?
    > > >
    > > > Thanks,
    > > >
    > > > Grant
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.