Error during compare in 5.x

Ahimoth

Since I installed SQL Compare 5.x, the comparison of one of my DB's is failing. However versions before 5.x work fine on this database. The error I get happens while creating a comparison project after hitting "Compare Now", it scripts the databases fine, but during the "Comparing" step it stops and says "unexpected char: 0xFFFF". I searched the entirety of syscomments for a binary value of 0xFF, but found nothing in both databases. Is there anyway to pinpoint the source of this error? If not how do I get around it?

Brian Donahue

Hello,

Does it still throw the error if you go into SQL Compare's options and ignore extended properties? It's fairly common for vendors to put binary data into an extended property, but SQL Compare seems to want to convert it to a Unicode string.

Andras B

Ahimoth wrote:

Since I installed SQL Compare 5.x, the comparison of one of my DB's is failing. However versions before 5.x work fine on this database. The error I get happens while creating a comparison project after hitting "Compare Now", it scripts the databases fine, but during the "Comparing" step it stops and says "unexpected char: 0xFFFF". I searched the entirety of syscomments for a binary value of 0xFF, but found nothing in both databases. Is there anyway to pinpoint the source of this error? If not how do I get around it?

Hi,
could you send me a screenshot of this error to Andras.Belokosztolszki at red-gate.com please? It would help me to identify which stage the error seems to occur. Also, does this error occur when you compare this database to any other database, or does this occur with a specific combinations of databases?

Regards,
Andras

Ahimoth

Email sent with the screenshot. I think I tried turning off extended properties, but I will try again just to be sure.

Thanks!

Ahimoth

Yes, it still errors out even after telling it to ignore extended properties.