xSQL Schema Compare SDK version 9.5 for SQL Server
ComparisonOptions Class Properties


For a list of all members of this type, see ComparisonOptions members.

Public Properties
 NameDescription
Public PropertyAbandonRemoteDataWhenDisablingArchiving Gets or sets the value that indicates whether the remote data should be abandoned when the table remote archiving or stretching is disabled.  
Public PropertyAlterFunctionWithDropCreate Gets or sets the value that indicates whether the functions should be altered using a DROP/CREATE statement instead of the ALTER statement.  
Public PropertyAlterProcedureWithDropCreate Gets or sets the value that indicates whether the stored procedures should be altered using a DROP/CREATE statement instead of the ALTER statement.  
Public PropertyAlterViewWithDropCreate Gets or sets the value that indicates whether the views should be altered using a DROP/CREATE statement instead of the ALTER statement.  
Public PropertyCompareAggregates Gets or sets the value that indicates whether the aggregates should be compared and synchronized.  
Public PropertyCompareAnsiNullsSetting Gets or sets the value that indicates whether the ANSI_NULLS attribute should be compared.  
Public PropertyCompareApplicationRoles Gets or sets the value that indicates whether application roles should be compared and synchronized.  
Public PropertyCompareAssemblies Gets or sets the value that indicates whether the database assemblies should be compared and synchronized.  
Public PropertyCompareAsymmetricKeys Gets or sets the value that indicates whether the asymmetric keys should be compared and synchronized.  
Public PropertyCompareBrokerContracts Gets or sets the value that indicates whether the service broker contracts should be compared and synchronized.  
Public PropertyCompareBrokerMessageTypes Gets or sets the value that indicates whether the service broker message types should be compared and synchronized.  
Public PropertyCompareBrokerPriorities Gets or sets the value that indicates whether the service broker priorities should be compared and synchronized.  
Public PropertyCompareBrokerQueues Gets or sets the value that indicates whether the service broker queues should be compared and synchronized.  
Public PropertyCompareBrokerRemoteBindings Gets or sets the value that indicates whether the remote service bindings should be compared and synchronized.  
Public PropertyCompareBrokerRoutes Gets or sets the value that indicates whether the service broker routes should be compared and synchronized.  
Public PropertyCompareBrokerServices Gets or sets the value that indicates whether the broker services should be compared and synchronized.  
Public PropertyCompareCertificates Gets or sets the value that indicates whether the certificates should be compared and synchronized.  
Public PropertyCompareCheckConstraints Gets or sets the value that indicates whether the check constraints should be compared and synchronized.  
Public PropertyCompareCheckedProperty Gets or sets the value that indicates whether the "checked" property of a check constraint or of a foreign key constraint should be compared.  
Public PropertyCompareClrDataTypes Gets or sets the value that indicates whether CLR types should be compared and synchronized.  
Public PropertyCompareColumnCollation Gets or sets the value that indicates whether the column collation should be compared and synchronized.  
Public PropertyCompareColumnEncryption Gets or sets the value that indicates whether the column encryption clause should be compared and synchronized.  
Public PropertyCompareColumnEncryptionKeys Gets or sets the value that indicates whether the column encryption keys should be compared and synchronized.  
Public PropertyCompareColumnMask Gets or sets the value that indicates whether the column dynamic mask should be compared and synchronized.  
Public PropertyCompareColumnMasterKeyPath Gets or sets the value that indicates whether the key path of a column master key should be compared.  
Public PropertyCompareColumnMasterKeyProvider Gets or sets the value that indicates whether the provider of a column master key should be compared.  
Public PropertyCompareColumnMasterKeys Gets or sets the value that indicates whether the column master keys should be compared and synchronized.  
Public PropertyCompareColumnOrdinal Gets or sets the value that indicates whether the order that the column appears in a table, should be compared and synchronized.  
Public PropertyCompareDatabaseFileGroups Gets or sets the value that indicates whether the database filegroups should be compared and synchronized.  
Public PropertyCompareDatabaseLogFiles Gets or sets the value that indicates whether database log files should be compared and synchronized.  
Public PropertyCompareDatabaseRoles Gets or sets the value that indicates whether database roles should be compared and synchronized.  
Public PropertyCompareDatabaseTriggers Gets or sets the value that indicates whether the database triggers should be compared and synchronized.  
Public PropertyCompareDataCompression Gets or sets the value that indicates whether data compression should be compared and synchronized. This option effects tables and indexes.  
Public PropertyCompareDefaultConstraints Gets or sets the value that indicates whether the default constraints should be compared and synchronized.  
Public PropertyCompareDefaults Gets or sets the value that indicates whether the stand-alone defaults should be compared and synchronized.  
Public PropertyCompareDiagramObjects Gets or sets the value that indicates whether the objects that support that SQL Server diagrams should be compared and synchronized.  
Public PropertyCompareExtendedProperties Gets or sets the value that indicates whether the extended properties should be compared and synchronized.  
Public PropertyCompareForeignKeys Gets or sets the value that indicates whether the foreign keys should be compared and synchronized.  
Public PropertyCompareFullTextCatalogs Gets or sets the value that indicates whether the full-text catalogs should be compared and synchronized.  
Public PropertyCompareFullTextIndexes Gets or sets the value that indicates whether the full-text indexes should be compared and synchronized.  
Public PropertyCompareFullTextStopLists Gets or sets the value that indicates whether the full-text stop lists should be compared and synchronized.  
Public PropertyCompareFullTextStopListWords Gets or sets the value that indicates whether the keywords associated with a full-text stop list should be compared and synchronized.  
Public PropertyCompareFunctions Gets or sets the value that indicates whether functions should be compared and synchronized.  
Public PropertyCompareHashIndexBucketCount Gets or sets the value that indicates whether the BUCKET_COUNT property of a hash index should be compared.  
Public PropertyCompareIdentity Gets or sets the value that indicates whether the column identity should be compared and synchronized.  
Public PropertyCompareIdentityIncrement Gets or sets the value that indicates whether the column identity increment should be compared and synchronized.  
Public PropertyCompareIdentitySeed Gets or sets the value that indicates whether the column identity seed should be compared and synchronized.  
Public PropertyCompareIndexColumnOrder Gets or sets the value that indicates whether the order of the columns in an index should be compared and synchronized.  
Public PropertyCompareIndexes Gets or sets the value that indicates whether indexes should be compared and synchronized.  
Public PropertyCompareIndexFillFactor Gets or sets the value that indicates whether the index FILLFACTOR property should be compared and synchronized.  
Public PropertyCompareIndexPadding Gets or sets the value that indicates whether the index PAD_INDEX property should be compared and synchronized.  
Public PropertyCompareIndexPageLocks Gets or sets the value that indicates whether the index ALLOW_PAGE_LOCKS property should be compared and synchronized.  
Public PropertyCompareIndexRowLocks Gets or sets the value that indicates whether the index ALLOW_ROW_LOCKS property should be compared and synchronized.  
Public PropertyCompareIndexStatsNoRecompute Gets or sets the value that indicates whether the index STATISTICS_NORECOMPUTE property should be compared and synchronized.  
Public PropertyCompareMemoryTables Indicates whether memory-optimized tables should be compared and synchronized.  
Public PropertyCompareNotForReplication Gets or sets the value that indicates whether the NOT FOR REPLICATION property should be compared and synchronized.  
Public PropertyCompareNullability Gets or sets the value that indicates whether the column NULL/NOT NULL property should be compared and synchronized.  
Public PropertyComparePartitionFunctions Gets or sets the value that indicates whether the partition functions should be compared and synchronized.  
Public PropertyComparePartitioning Gets or sets the value that indicates whether partitioning should be compared for tables and indexes.  
Public PropertyComparePartitionSchemes Gets or sets the value that indicates whether the partition schemes should be compared and synchronized.  
Public PropertyComparePermissions Gets or sets the value that indicates whether the permissions should be compared and synchronized.  
Public PropertyComparePrimaryKey Gets or sets the value that indicates whether primary keys should be compared and synchronized.  
Public PropertyCompareProcedures Gets or sets the value that indicates whether the stored procedures should be compared and synchronized.  
Public PropertyCompareQuotedIdentifierSetting Gets or sets the value that indicates whether the QUOTED_IDENTIFIER attribute should be compared.  
Public PropertyCompareRemoteDataArchiving Gets or sets the value that indicates whether the table remote data archiving or stretching should be compared and synchronized.  
Public PropertyCompareReplicatedTables Gets or sets the value that indicates whether replicated tables should be compared and synchronized.  
Public PropertyCompareRules Gets or sets the value that indicates whether the rules should be compared and synchronized.  
Public PropertyCompareSchemas Gets or sets the value that indicates whether database schemas should be compared and synchronized.  
Public PropertyCompareSearchPropertyLists Gets or sets the value that indicates whether the search property lists should be compared and synchronized.  
Public PropertyCompareSecurityPolicies Gets or sets the value that indicates whether the security policies should be compared and synchronized.  
Public PropertyCompareSequenceMaxValue Gets or sets the value that indicates whether the max value of a sequence should be compared and synchronized.  
Public PropertyCompareSequenceMinValue Gets or sets the value that indicates whether the min value of a sequence should be compared and synchronized.  
Public PropertyCompareSequences Gets or sets the value that indicates whether the sequences should be compared and synchronized.  
Public PropertyCompareSequenceStartValue Gets or sets the value that indicates whether the start value of a sequence should be compared and synchronized.  
Public PropertyCompareSpatialIndexes Gets or sets the value that indicates whether spatial indexes should be compared and synchronized.  
Public PropertyCompareStatistics Gets or sets the value that indicates whether the statistics should be compared and synchronized.  
Public PropertyCompareSymmetricKeys Gets or sets the value that indicates whether the symmetric keys should be compared and synchronized.  
Public PropertyCompareSynonymDatabase Gets or sets the value that indicates whether the database property of the base object of a synonym name should be compared and synchronized.  
Public PropertyCompareSynonyms Gets or sets the value that indicates whether the synonyms should be compared and synchronized.  
Public PropertyCompareSynonymServer Gets or sets the value that indicates whether the server property of the base object of a synonym name should be compared and synchronized.  
Public PropertyCompareSystemVersioning Gets or sets the value that indicates whether the system-versioning should be compared. It effects the system-versioning of tables and memory tables.  
Public PropertyCompareTableChangeDataCapture Indicates whether the change data capture attribute of database tables should be compared and synchronized.  
Public PropertyCompareTableChangeTracking Indicates whether the change tracking attribute of database tables should be compared and synchronized.  
Public PropertyCompareTableLockEscalation Indicates whether the lock escalation attribute of database tables should be compared and synchronized.  
Public PropertyCompareTables Gets or sets the value that indicates whether tables should be compared and synchronized.  
Public PropertyCompareTriggers Gets or sets the value that indicates whether triggers should be compared and synchronized.  
Public PropertyCompareUniqueConstraints Gets or sets the value that indicates whether unique constraints should be compared and synchronized.  
Public PropertyCompareUserDefinedDataTypes Gets or sets the value that indicates whether user-defined data types should be compared and synchronized.  
Public PropertyCompareUserDefinedTableTypes Gets or sets the value that indicates whether user-defined table types should be compared and synchronized.  
Public PropertyCompareUserLogin Gets or sets the value that indicates whether the login associated with a database user should be compared.  
Public PropertyCompareUsers Gets or sets the value that indicates whether database users should be compared and synchronized.  
Public PropertyCompareViews Gets or sets the value that indicates whether the views should be compared and synchronized.  
Public PropertyCompareXmlIndexes Gets or sets the value that indicates whether xml indexes should be compared and synchronized.  
Public PropertyCompareXmlSchemaCollections Gets or sets the value that indicates whether xml schema collections should be compared and synchronized.  
Public PropertyContinueExecutionOnError Gets or sets the value that indicates whether the execution of the schema synchronization script should continue, if possible, when an error occurs.  
Public PropertyDropSystemVersioningHistoryTable Gets or sets the value that indicates whether the history associated with a system-versioned table should be dropped when the table is dropped or when the table system-versioning is disabled.  
Public PropertyExecuteTransactionalScript Gets or sets the value that indicates whether the synchronization script should be executed as a transactional script.  
Public PropertyFileGroupComparisonOption Gets or sets the filegroup comparison option.  
Public PropertyFileGroupMappings Gets the collection of custom mappings to be used for database filegroups.  
Public PropertyFileStreamFileGroupComparisonOption Gets or sets the filestream filegroup comparison option.  
Public PropertyFileStreamFileGroupMappings Gets the collection of custom mappings for filestream filegroups.  
Public PropertyGenerateCheckAbsenceStatement Gets or sets the value that indicates whether a check for absence should be performed before creating an object.  
Public PropertyGenerateCheckExistenceStatement Gets or sets the value that indicates whether a check for existence should be performed before dropping an object.  
Public PropertyGenerateTransactionalScript Gets or sets the value that indicates whether the synchronization script should be generated as a transactional script.  
Public PropertyGenerateUseDatabaseStatement Gets or sets the value that indicates whether the synchronization script should contain a USE <database> statement.  
Public PropertyIgnoreCaseInDefinition Gets or sets the value that indicates whether the character case should be ignored when comparing the object's definition. It effects views, procedures, functions and triggers.  
Public PropertyIgnoreCheckConstraintName Gets or sets the value that indicates whether the name of check constraints should be ignored.  
Public PropertyIgnoreDefaultConstraintName Gets or sets the value that indicates whether the default constraint name should be ignored.  
Public PropertyIgnoreFunctionComments Gets or sets the value that indicates whether the SQL comments in the function definition should be ignored.  
Public PropertyIgnoreNameInDefinition Gets or sets the value that indicates whether the name portion in the object's definition should be ignored. It effects views, procedures, functions and triggers.  
Public PropertyIgnorePrimaryKeyName Gets or sets the value that indicates whether primary key name should be ignored.  
Public PropertyIgnoreProcedureComments Gets or sets the value that indicates whether the SQL comments in the definition of a stored procedure should be ignored.  
Public PropertyIgnoreSpacesInDefinition Gets or sets the value that indicates whether white spaces should be ignored in the object's definition. It effects views, procedures, functions and triggers.  
Public PropertyIgnoreSystemVersioningHistoryTableName Gets or sets the value that indicates whether the name of the history table, used by the system-versioning, should be ignored when two temporal tables compared.  
Public PropertyIgnoreTriggerComments Gets or sets the value that indicates whether the SQL comments in the trigger definition should be ignored.  
Public PropertyIgnoreViewComments Gets or sets the value that indicates whether the SQL comments in the definition of a view should be ignored.  
Public PropertyIncludeDependantObjects Gets or sets the value the indicates whether the dependencies should be included in the synchronization script.  
Public PropertyLogScriptExecution Gets or sets the value that indicates that T-SQL script fragments that sent to SQL Server should be logged to a file.  
Public PropertyPreventSchemaDrop Gets or sets the value that indicates whether the synchronization script should not generate the statements that drop a database schema.  
Public PropertyScriptAnsiNullsSetting Gets or sets the value that indicates whether the ANSI_NULLS property should be scripted.  
Public PropertyScriptAnsiPaddingSetting Gets or sets the value that indicates whether the ANSI_PADDING property should be scripted.  
Public PropertyScriptCollation Gets or sets the value that indicates whether the column collation property should be scripted.  
Public PropertyScriptColumnEncryption Gets or sets the value that indicates whether the column's ENCRYPTED WITH(...) clause should be scripted.  
Public PropertyScriptColumnMask Gets or sets the value that indicates whether the column's MASKED WITH(...) clause should be scripted.  
Public PropertyScriptConstraintsWithNoCheck Gets or sets the value that indicates whether the check constraints should be scripted with NOCHECK option.  
Public PropertyScriptDataCompression Gets or sets the value that indicates whether the data compression attribute of a table or index should be scripted.  
Public PropertyScriptFileGroup Gets or sets the value that indicates whether the filegroup property of a table or index should be scripted.  
Public PropertyScriptFullTextCatalogPath Gets or sets the value that indicates whether the full-text catalog path property should be scripted.  
Public PropertyScriptHistoryRemoteDataArchiving Gets or sets the value that indicates whether the table remote data archiving clause of the temporal history table should be scripted.  
Public PropertyScriptNewColumnsAsNull Gets or sets the value that indicates whether the missing columns that do not allow NULL should be scripted as nullable.  
Public PropertyScriptQuotedIdentifierSetting Gets or sets the value that indicates whether the QUOTED_IDENTIFIER property should be scripted.  
Public PropertyScriptRemoteDataArchiving Gets or sets the value that indicates whether the table remote data archiving clause should be scripted.  
Public PropertyScriptSequenceMaxValue Gets or sets the value that indicates whether the sequence max value should be scripted.  
Public PropertyScriptSequenceMinValue Gets or sets the value that indicates whether the sequence min value should be scripted.  
Public PropertyScriptSequenceStartValue Gets or sets the value that indicates whether the sequence start value should be scripted.  
Public PropertyScriptSystemVersioning Gets or sets the value that indicates whether the system-versioning of a table or memory table should be scripted.  
Public PropertyScriptTableChangeDataCapture Gets or sets the value that indicates whether the change data capture of a table should be scripted.  
Public PropertyScriptTableChangeTracking Gets or sets the value that indicates whether the change tracking of a table should be scripted.  
Public PropertyScriptTableLockEscalation Gets or sets the value that indicates whether the lock escalation of a table should be scripted.  
Public PropertyStandardizeNameInDefinition Indicates that the synchronization script should standardize the object name in the definition. The name will be formatted as [schema].[name]. This option effects only views, procedures, functions and triggers.  
Public PropertyTransactionSize Gets or sets the max size, in bytes, of the transaction under which the synchronization script runs.  
Top
See Also

Reference

ComparisonOptions Class
xSQL.SchemaCompare.SqlServer Namespace

 

 


┬ęCopyright 2018 xSQL Software. All Rights Reserved.

Send Feedback