None.

None.

If two columns of data differ only by the number of spaces at the end of the string, SQL Data Compare considers the data to be identical. The trailing spaces are not included in the synchronization script. This option does not apply to CLR or variant columns.

For all string data types, forces binary collation irrespective of column collation, resulting in a case-sensitive comparison. When this option is selected and the comparison key is a string, this may result in slower performance because the indexes are not used.

When you are comparing tables or views with a large volume of data that changes infrequently, if you set this option, a checksum is used to compare the data. If the checksums differ, the data is compared; if the checksums are the same, the data is not compared. On SQL Server 2000 the connected user must be a member of the db_owner role or the system administrator role. This option applies only to SQL Server 2000 or later.

Compresses the temporary files that SQL Data Compare generates while performing the comparison. This reduces the possibility of running out of temporary disk space when comparing very large databases. When you select this option, you will not be able to sort the results of the comparison.