Incorrect Data Comparison?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 14, 2004 11:02AM in SQL Data Compare Previous Versions
Hi,

SQL Data Compare is entirely case-sensitive, so it cannot compare text values with mixed case. If you synchronized these values, then it would work alright provided you's chosed to synchronize missing and additional values. If you skip one of either of those, then you may have problems because it would insert duplicate values and violate a unique constraint on a database with case-insensitive collation.
This discussion has been closed.