RedGate.SQLDataCompare.Engine Namespace : SqlOptions Enumeration (RedGate.SQLDataCompare.Engine) |
Options used when synchronizing databases.
Member | Description |
---|---|
Default | A 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. |
DDLTriggerDisable | Disable 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. |
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)
RedGate.SQLDataCompare.Engine Namespace
© 2003 - 2006 Red Gate Software Ltd. All Rights Reserved.