Problem while comparing two tables that both have only one field

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
Hi Eric,

If the Primary Key is varchar, there is a possibility that the data is
showing as additional and missing for two reasons:

-It may be different because there are leading and trailing spaces in the
varchar column.
-It is simultaneously missing andf additional because the only column you
are comparing is also the primary key. Since it thinks all of the PK values
are different, it's going to list the data in both the missing and
additional columns.

Hopefully that makes some sense.

Regards,

Brian Donahue
Red Gate Technical Support

"Eric Sun" <esun@kisp.com> wrote in message
news:MHRM0PTZEHA.2428@server53...
> Hi,
>
> I am using the latest SQL Data Compare 3.37 to compare two tables that
have
> only one field (varchar, 20). The only one field is also primary key.
>
> The problem we found is that some data exist in both the missing list and
> additional list. Make no sense.
>
> Could you please help to check if there is anything wrong? We can provide
> screenshots and/or data if you want.
>
> Thanks a lot.
>
> Eric
>
>
This discussion has been closed.