RedGate.SQLCompare.Engine Namespace : Options Enumeration

Options used when comparing and synchronizing databases.

Members

Member	Description
None	None.
Default	The default options for a comparison. These are: IgnoreFileGroups IgnoreFillFactor IgnoreUserProperties IgnoreWhiteSpace IgnoreWithElementOrder IncludeDependencies
ForceColumnOrder	Force table column order to be identical.
IgnoreFillFactor	Ignore fill factor.
IgnorePermissions	Ignore permissions.
IgnoreWhiteSpace	Ignore white space.
IgnoreBindings	Ignore bindings.
IgnoreQuotedIdentifiersAndAnsiNullSettings	Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS statements.
CaseSensitiveObjectDefinition	Treat items as case sensitive.
IgnoreExtendedProperties	Ignore extended properties
IgnoreFullTextIndexing	Ignore full text indexing.
NoSQLPlumbing	Do not include plumbing for transactional synchronization scripts.
IgnoreCollations	Ignore collation order.
IgnoreComments	Ignore comments.
IgnoreIndexes	Ignore indexes.
IgnoreKeys	Ignore foreign keys.
IgnoreChecks	Ignore check constraints.
IgnoreTriggers	Ignore DML triggers.
IncludeDependencies	Include dependencies.
IgnoreInsteadOfTriggers	Ignore INSTEAD OF triggers.
IgnoreFileGroups	Ignore filegroups, partition schemes, and partition functions.
IgnoreIdentitySeedAndIncrement	Ignore identity seed and increment values.
IgnoreWithNocheck	Ignore WITH NOCHECK on foreign keys and check constraints.
IgnoreConstraintNames	Ignore constraint names.
IgnoreStatistics	Ignore statistics.
DoNotOutputCommentHeader	Do not output comment header.
AddWithEncryption	Add WITH ENCRYPTION option to stored procedures etc.
IgnoreSynonymDependencies	Ignore dependencies through synonyms.
SeparateTriggers	Separate triggers from tables and views.
IgnoreOwners	Ignore owners when checking for equality.
IgnoreQueueEventNotifications	Ignore event notifications on queues.
TargetIsPreYukon	Flag target database as prior to SQL Server 2005. Internal use only.
UseClrUdtToStringForClrMigration	If a CLR assembly must be changed, unbind the dependent types from tables using ToString, and then convert these table values back to CLR type.
ConsiderNextFilegroupInPartitionSchemes	If set, the next filegroups in partition schemes are compared with the filegroups that have a partition range associated with them.
IgnoreCertificatesAndCryptoKeys	Ignore certificates, symmetric keys, and asymmetric keys in SQL Server 2005 databases.
IgnoreTriggerOrder	Ignore trigger order.
IgnoreUsers	Ignore users' permissions and role memberships.
IgnoreUserProperties	Ignore user properties.
DisableAndReenableDdlTriggers	Disable and later re-enable DDL triggers. SQL Server 2005 only.
IgnoreWithElementOrder	Ignore the order of with elements in non CLR stored procedures, functions, triggers, DDL triggers, and views.
IgnoreIndexLockProperties	Ignore the lock properties of indexes.
IgnoreReplicationTriggers	Ignore replication triggers.
IgnoreIdentityProperties	Ignores identity properties.

Requirements

Namespace: RedGate.SQLCompare.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.SQLCompare.Engine (in RedGate.SQLCompare.Engine.dll)

See Also

RedGate.SQLCompare.Engine Namespace

 

 

---

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