See Also

RedGate.SQLDataCompare.Engine Namespace

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)

Language

Visual Basic

C#

C++

C++/CLI

Show All

See AlsoLanguages Requirements RedGate.SQLDataCompare.Engine Send comments on this topic.

SqlOptions Enumeration

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

Options used when synchronizing databases.

Members

MemberDescription
DefaultA set of defaults.
None None.
DisableTriggers Disable, then re-enable, DML triggers on tables and views in the synchronization script.
DisableKeys Disable, then re-enable, foreign keys in the synchronization script. Note that in some circumstances foreign keys are dropped and recreated rather than disabled and re-enabled.
DropConstraintsAndIndexes Drop and recreate primary keys, indexes, and unique constraints in the synchronization script. If the primary key, index, or unique constraint is the comparison key, it cannot be dropped.
OutputCommentHeader Include the comment header in the synchronization script. The comment header contains information about the databases that you are comparing, and the version of SQL Data Compare.
UseTransactions Inserts BEGIN TRANSACTION at the beginning of the synchronization script and COMMIT TRANSACTION at the end of the synchronization script.
TransportCLRBinary In the synchronization script, SQL Data Compare can use the binary representation or the string representation (.ToString()) of the CLR column. Setting this option forces SQL Data Compare to use the binary representation in the synchronization script. The binary representations of the CLR columns must be the same.
DDLTriggerDisableDisable and then re-enable all DDL triggers in the synchronization script.
OutputComments Include the comments in the output script. The comments make it easier to locate items in the output.

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.