Michelle Taylor wrote:Are you talking about SQL Compare (which compares schema) or SQL Data Compare (which compares data)?
SQL Data Compare.
For example, our database uses a lot of fields defined as FLOAT(), which only use a total of 32 bits for storage -- 24 bits for the mantissa -- providing only 7 decimal digits of guaranteed precision. Apparently, there are some slight differences in the "rounding" between the two platforms, whether in the FP processor or software, such that the numbers often differ past that. I'd say that SQL Server is converting them on output to a greater precision.
For example, the numbers
are displayed by SQL Data Compare as:
109.05999755859375 (32-bit SQL2000)
109.05999755859381 (64-bit SQL2005)
102.80999755859375 (32-bit SQL2000)
102.80999755859381 (64-bit SQL2005)
Knowing that the precision of these numbers is limited to 7 significant digits, they might be rounded and compared as: