Bug report for SQL Data Compare 2.02
Brian Donahue
Posts: 6,590 Bronze 1
Hi Nadya,
If you attempt to compare TEXT, NTEXT, or IMAGE columns, you will get
this error. SQL Data Compare can't handle blobs in this version. If the
amount of data in the text field is small, SQL Data Compare may work despite
that.
I hope that's the problem solved.
Brian Donahue
Technical Support
"Nadya" <nadya@nadya.com> wrote in message news:6nyuKukJDHA.1804@server53...
> Hi everybody,
>
> I've got a question about PTS Data Compare. Today I made a copy of a SQL
> Server 2000 database, then attempted to compare the copy with the
original.
> (They should be the same now, but will start changing next week.) I
> expected that I might have a few different records, but I'm surprised to
> discover that a lot of my tables are marked "Has Incomparable Columns." I
> looked at the schemas for both versions of one of these tables, and it
looks
> to me like they have the same columns.
>
> Does anyone have any suggestions?
>
> Thanks,
>
> Nadya
>
>
If you attempt to compare TEXT, NTEXT, or IMAGE columns, you will get
this error. SQL Data Compare can't handle blobs in this version. If the
amount of data in the text field is small, SQL Data Compare may work despite
that.
I hope that's the problem solved.
Brian Donahue
Technical Support
"Nadya" <nadya@nadya.com> wrote in message news:6nyuKukJDHA.1804@server53...
> Hi everybody,
>
> I've got a question about PTS Data Compare. Today I made a copy of a SQL
> Server 2000 database, then attempted to compare the copy with the
original.
> (They should be the same now, but will start changing next week.) I
> expected that I might have a few different records, but I'm surprised to
> discover that a lot of my tables are marked "Has Incomparable Columns." I
> looked at the schemas for both versions of one of these tables, and it
looks
> to me like they have the same columns.
>
> Does anyone have any suggestions?
>
> Thanks,
>
> Nadya
>
>
This discussion has been closed.
