RedGate.SQLDataCompare.Engine Namespace : ComparisonOptions Enumeration (RedGate.SQLDataCompare.Engine)

Options used when comparing databases.

Members

Member	Description
Default	A set of defaults.
None	None.
TrimTrailingSpaces	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.
ForceBinaryCollation	If the comparison key is a string, this option forces a binary collation on all string sorting. When you use this option indexes are ignored.
UseChecksumComparison	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.

Requirements

Namespace: RedGate.SQLDataCompare.Engine

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: RedGate.SQLDataCompare.Engine (in RedGate.SQLDataCompare.Engine.dll)

See Also

RedGate.SQLDataCompare.Engine Namespace

 

 

---

© 2003 - 2006 Red Gate Software Ltd. All Rights Reserved.