xSQL.SchemaCompare.SqlServer Namespace

Classes

	Class	Description
	AssemblyInfo	Provides information about the current assembly.
	CollectionDescriptorAttribute	A descriptor for a collection of SQL Server objects.
	ComparisonOptionDescriptorAttribute	Marks the type of a comparison option.
	ComparisonOptions	Provides options that determine how that database schema is compared and synchronized.
	DatabaseTriggerPairBase<T>	Provides the base class for a pair of database triggers.
	EntityMapping	Provides mapping semantic for database entities.
	EntityMappingFactory	Provides a registry for database entity mappings.
	ExecutionLogger	Provides logging during the execution of the schema synchronization script.
	FunctionPairBase<T>	Represents the base class for a pair of functions.
	PairBase	Represents the base class for a pair of database entities.
	PairBaseEventArgs	Provides data for schema compare events.
	PairCollectionBase<TPair,TItem>	Provides the base class for a collection of pairs.
	ProcedurePairBase<T>	Provides the base class for a pair of procedures.
	ProgressEventArgs	Provides data to the schema comparison progress event.
	SchemaCompareException	Represents an exception that is thrown during schema compare operations.
	SchemaCompareSession	Provides information related to a comparison session.
	SchemaDiffExtractor	Generates a schema differences extract, in either xml or html format, and saves it to a file.
	SchemaDiffExtractorSettings	Provides settings for the SchemaDiffExtractor.
	SchemaFilter	Represents a schema filter.
	SchemaFilterCollection	Represents a collection of SchemaFilter elements.
	SchemaFilterCriteria	Represents the selection conditions for a schema filter.
	SchemaFilterCriteriaCollection	Represents a collection of SchemaFilterCriteria elements.
	SchemaScriptEventArgs	Provides data to the event raised during the generation of the schema synchronization script.
	SchemaScriptFragment	Represents a script fragment, which is a portion of the schema script for a database object.
	SchemaScriptFragmentCollection	Represents a collection of SchemaScriptFragment elements.
	ScriptExecutionException	Represents an exception that is thrown during the execution of the schema synchronization script.
	ScriptManager	Provides access to the schema synchronization script.
	SqlAggregatePair	Represents a pair of xSQL.Schema.SqlServer.SqlAggregate objects.
	SqlAggregatePairCollection	Represents a collection of SqlAggregatePair elements.
	SqlAggregatePairEventArgs	Provides data to the event raised during the comparison of aggregates.
	SqlApplicationRolePair	Represents a pair of xSQL.Schema.SqlServer.SqlApplicationRole objects.
	SqlApplicationRolePairCollection	Represents a collection of SqlApplicationRolePair entities.
	SqlApplicationRolePairEventArgs	Provides data to the event raised during the comparison of application roles
	SqlAssemblyFilePair	Represents a pair of xSQL.Schema.SqlServer.SqlAssemblyFile objects.
	SqlAssemblyFilePairCollection	Represents a collection of SqlAssemblyFilePair elements.
	SqlAssemblyPair	Represents a pair of xSQL.Schema.SqlServer.SqlAssembly objects.
	SqlAssemblyPairCollection	Represents a collection of SqlAssemblyPair elements.
	SqlAssemblyPairEventArgs	Provides data to the event raised during the comparison of assemblies.
	SqlAsymmetricKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlAsymmetricKey objects.
	SqlAsymmetricKeyPairCollection	Represents a collection of SqlAsymmetricKeyPair entities.
	SqlAsymmetricKeyPairEventArgs	Provides data to the event raised during the comparison of asymmetric keys.
	SqlBrokerContractPair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerContract objects.
	SqlBrokerContractPairCollection	Represents a collection of SqlBrokerContractPair objects.
	SqlBrokerContractPairEventArgs	Provides data to the event raised during the comparison of broker contracts.
	SqlBrokerMessageTypeMappingPair	Represents a pair of message types mapped to a broker contract.
	SqlBrokerMessageTypeMappingPairCollection	Represents a collection of SqlBrokerMessageTypeMappingPair entities.
	SqlBrokerMessageTypePair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerMessageType objects.
	SqlBrokerMessageTypePairCollection	Represents a collection of SqlBrokerMessageTypePair entities.
	SqlBrokerMessageTypePairEventArgs	Provides data to the event raised during the comparison of broker message types.
	SqlBrokerPriorityPair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerPriority objects.
	SqlBrokerPriorityPairCollection	Represents a collection of SqlBrokerPriorityPair entities.
	SqlBrokerPriorityPairEventArgs	Provides data to the event raised during the comparison of broker priorities.
	SqlBrokerQueuePair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerQueue objects.
	SqlBrokerQueuePairCollection	Represents a collection of SqlBrokerQueuePair entities.
	SqlBrokerQueuePairEventArgs	Provides data to the event raised during the comparison of broker queues.
	SqlBrokerRemoteServiceBindingPair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerRemoteServiceBinding objects.
	SqlBrokerRemoteServiceBindingPairCollection	Represents a collection of SqlBrokerRemoteServiceBindingPair entities.
	SqlBrokerRemoteServiceBindingPairEventArgs	Provides data to the event raised during the comparison of broker remote service bindings.
	SqlBrokerRoutePair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerRoute of objects.
	SqlBrokerRoutePairCollection	Represents a collection of SqlBrokerRoutePair entities.
	SqlBrokerRoutePairEventArgs	Provides data to the event raised during the comparison of broker routes.
	SqlBrokerServicePair	Represents a pair of xSQL.Schema.SqlServer.SqlBrokerService objects.
	SqlBrokerServicePairCollection	Represents a collection of SqlBrokerServicePair entities.
	SqlBrokerServicePairEventArgs	Provides data to the event raised during the comparison of broker services.
	SqlCertificatePair	Represents a pair of xSQL.Schema.SqlServer.SqlCertificate objects.
	SqlCertificatePairCollection	Represents a collection of SqlCertificatePair entities.
	SqlCertificatePairEventArgs	Provides data to the event raised during the comparison of certificates.
	SqlCheckConstraintPair	Represents a pair of xSQL.Schema.SqlServer.SqlCheckConstraint objects.
	SqlCheckConstraintPairCollection	Represents a collection of SqlCheckConstraintPair entities.
	SqlCheckConstraintPairEventArgs	Provides data to the event raised during the comparison of check constraints.
	SqlClrDatabaseTriggerPair	Represents a pair of xSQL.Schema.SqlServer.SqlClrDatabaseTrigger entities.
	SqlClrDatabaseTriggerPairCollection	Represents a collection of SqlClrDatabaseTriggerPair objects.
	SqlClrDatabaseTriggerPairEventArgs	Provides data to the event raised during the comparison of CLR database triggers.
	SqlClrDataTypePair	Represents a pair of xSQL.Schema.SqlServer.SqlClrDataType objects.
	SqlClrDataTypePairCollection	Represents a collection of SqlClrDataTypePair entities.
	SqlClrDataTypePairEventArgs	Provides data to the event raised during the comparison of CLR data types.
	SqlClrFunctionPair	Represents a pair of xSQL.Schema.SqlServer.SqlClrFunction entities.
	SqlClrFunctionPairCollection	Represents a collection of SqlClrFunctionPair entities.
	SqlClrFunctionPairEventArgs	Provides data to the event raised during the comparison of CLR functions.
	SqlClrProcedurePair	Represents a pair of xSQL.Schema.SqlServer.SqlClrProcedure entities.
	SqlClrProcedurePairCollection	Represents a collection of SqlClrProcedurePair entities.
	SqlClrProcedurePairEventArgs	Provides data to the event raised during the comparison of CLR procedures.
	SqlClrTriggerPair	Represents a pair of xSQL.Schema.SqlServer.SqlClrTrigger objects.
	SqlClrTriggerPairCollection	Represents a collection of SqlClrTriggerPair entities.
	SqlClrTriggerPairEventArgs	Provides data to the event raised during the comparison of CLR triggers.
	SqlColumnEncryptionKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlColumnEncryptionKey objects.
	SqlColumnEncryptionKeyPairCollection	Represents a collection of SqlColumnEncryptionKeyPair entities.
	SqlColumnEncryptionKeyPairEventArgs	Provides data to the event raised during the comparison of the column encryption keys.
	SqlColumnEncryptionKeyValuePair	Represents a pair of xSQL.Schema.SqlServer.SqlColumnEncryptionKeyValue objects.
	SqlColumnEncryptionKeyValuePairCollection	Represents a collection of SqlColumnEncryptionKeyValuePair elements.
	SqlColumnMasterKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlColumnMasterKey objects.
	SqlColumnMasterKeyPairCollection	Represents a collection of SqlColumnMasterKeyPair entities.
	SqlColumnMasterKeyPairEventArgs	Provides data to the event raised during the comparison of column master keys.
	SqlColumnPair	Represents a pair of xSQL.Schema.SqlServer.SqlColumn objects.
	SqlColumnPairCollection	Represents a collection of SqlColumnPair objects.
	SqlColumnPairEventArgs	Provides data to the event raised during the comparison of columns.
	SqlDatabasePair	Represents a pair of xSQL.Schema.SqlServer.SqlDatabase objects.
	SqlDatabaseRolePair	Represents a pair of xSQL.Schema.SqlServer.SqlDatabaseRole objects.
	SqlDatabaseRolePairCollection	Represents a collection of SqlDatabaseRolePair elements.
	SqlDatabaseRolePairEventArgs	Provides data to the event raised during the comparison of database roles.
	SqlDatabaseTriggerPair	Represents a pair of xSQL.Schema.SqlServer.SqlDatabaseTrigger entities.
	SqlDatabaseTriggerPairCollection	Represents a collection of SqlDatabaseTriggerPair objects.
	SqlDatabaseTriggerPairEventArgs	Provides data to the event raised during the comparison of database triggers.
	SqlDataFilePair	Represents a pair of xSQL.Schema.SqlServer.SqlDataFile objects.
	SqlDataFilePairCollection	Represents a collection of SqlDataFilePair elements.
	SqlDefaultConstraintPair	Represents a pair of xSQL.Schema.SqlServer.SqlDefaultConstraint objects.
	SqlDefaultConstraintPairCollection	Represents a collection of SqlDefaultConstraintPair entities.
	SqlDefaultConstraintPairEventArgs	Provides data to the event raised during the comparison of default constraints.
	SqlDefaultPair	Represents a collection of xSQL.Schema.SqlServer.SqlDefault entities.
	SqlDefaultPairCollection	Represents a collection of SqlDefaultPair entities.
	SqlDefaultPairEventArgs	Provides data to the event raised during the comparison of defaults.
	SqlEdgeConstraintPair	Represents a pair of xSQL.Schema.SqlServer.SqlEdgeConstraint objects.
	SqlEdgeConstraintPairCollection	Represents a collection of SqlEdgeConstraintPair entities.
	SqlEdgeConstraintPairEventArgs	Provides data to the event raised during the comparison of edge constraints.
	SqlEntityPairEventArgs<TPair,T>	Provides data to the event raised during the comparison of database entities.
	SqlExtendedPropertyPair	Represents a pair of xSQL.Schema.SqlServer.SqlExtendedProperty entities.
	SqlExtendedPropertyPairCollection	Represents a collection of SqlExtendedPropertyPair entities.
	SqlExtendedPropertyPairEventArgs	Provides data to the event raised during the comparison of extended properties.
	SqlFileGroupPair	Represents a pair of xSQL.Schema.SqlServer.SqlFileGroup entities.
	SqlFileGroupPairCollection	Represents a collection of SqlFileGroupPair elements.
	SqlFileGroupPairEventArgs	Provides data to the event raised during the comparison of filegroups.
	SqlForeignKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlForeignKey objects.
	SqlForeignKeyPairCollection	Represents a collection of SqlForeignKeyPair entities.
	SqlForeignKeyPairEventArgs	Provides data to the event raised during the comparison of foreign keys.
	SqlFullTextCatalogPair	Represents a pair of xSQL.Schema.SqlServer.SqlFullTextCatalog objects.
	SqlFullTextCatalogPairCollection	Represents a collection of SqlFullTextCatalogPair entities.
	SqlFullTextCatalogPairEventArgs	Provides data to the event raised during the comparison of full-text catalogs.
	SqlFullTextIndexPair	Represents a pair of xSQL.Schema.SqlServer.SqlFullTextIndex objects.
	SqlFullTextIndexPairEventArgs	Provides data to the event raised during the comparison of full-text indexes.
	SqlFullTextStopListPair	Represents a pair of xSQL.Schema.SqlServer.SqlFullTextStopList objects.
	SqlFullTextStopListPairCollection	Represents a collection of SqlFullTextStopListPair entities.
	SqlFullTextStopListPairEventArgs	Provides data to the event raised during the comparison of full-text stop lists.
	SqlFunctionPair	Represents a pair of xSQL.Schema.SqlServer.SqlFunction entities.
	SqlFunctionPairCollection	Represents a collection of SqlFunctionPair entities.
	SqlFunctionPairEventArgs	Provides data to the event raised during the comparison of user-defined functions.
	SqlIndexPair	Represents a pair of xSQL.Schema.SqlServer.SqlIndex objects.
	SqlIndexPairCollection	Represents a collection of SqlIndexPair entities.
	SqlIndexPairEventArgs	Provides data to the event raised during the comparison of indexes.
	SqlLogFilePair	Represents a pair of xSQL.Schema.SqlServer.SqlLogFile objects.
	SqlLogFilePairCollection	Represents a collection of SqlLogFilePair elements.
	SqlLogFilePairEventArgs	Provides data to the event raised during the comparison of log files.
	SqlMemoryTablePair	Represents a pair of xSQL.Schema.SqlServer.SqlMemoryTable objects.
	SqlMemoryTablePairCollection	Represents a collection of SqlMemoryTablePair entities.
	SqlMemoryTablePairEventArgs	Provides data to the event raised during the comparison of memory tables.
	SqlPairBase<TItem>	Represents the base class for a pair of SQL Server database entities.
	SqlPartitionFunctionPair	Represents a pair of xSQL.Schema.SqlServer.SqlPartitionFunction objects.
	SqlPartitionFunctionPairCollection	Represents a collection of SqlPartitionFunctionPair entities.
	SqlPartitionFunctionPairEventArgs	Provides data to the event raised during the comparison of partition functions.
	SqlPartitionSchemePair	Represents a pair of xSQL.Schema.SqlServer.SqlPartitionScheme objects.
	SqlPartitionSchemePairCollection	Represents a collection of SqlPartitionSchemePair entities.
	SqlPartitionSchemePairEventArgs	Provides data to the event raised during the comparison of partition schemes.
	SqlPermissionPair	Represents a pair of xSQL.Schema.SqlServer.SqlPermission entities.
	SqlPermissionPairCollection	Represents a collection of SqlPermissionPair entities.
	SqlPermissionPairEventArgs	Provides data to the event raised during the comparison of permissions.
	SqlPrimaryKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlPrimaryKey objects.
	SqlPrimaryKeyPairEventArgs	Provides data to the event raised during the comparison of primary keys.
	SqlProcedurePair	Represents a pair of xSQL.Schema.SqlServer.SqlProcedure entities.
	SqlProcedurePairCollection	Represents a collection of SqlProcedurePair entities.
	SqlProcedurePairEventArgs	Provides data to the event raised during the comparison of stored procedures.
	SqlRulePair	Represents a pair of xSQL.Schema.SqlServer.SqlRule entities.
	SqlRulePairCollection	Represents a collection of SqlRulePair entities.
	SqlRulePairEventArgs	Provides data to the event raised during the comparison of rules.
	SqlSchemaCompare	Represents the main class for comparing and synchronizing two SQL Server databases.
	SqlSchemaPair	Represents a pair of xSQL.Schema.SqlServer.SqlSchema objects.
	SqlSchemaPairCollection	Represents a collection of SqlSchemaPair entities.
	SqlSchemaPairEventArgs	Provides data to the event raised during the comparison of database schemas.
	SqlSearchPropertyListPair	Represents a pair of xSQL.Schema.SqlServer.SqlSearchPropertyList objects.
	SqlSearchPropertyListPairCollection	Represents a collection of SqlSearchPropertyListPair entities.
	SqlSearchPropertyListPairEventArgs	Provides data to the event raised during the comparison of search property lists.
	SqlSearchPropertyPair	Represents a pair of properties associated with a search property list.
	SqlSearchPropertyPairCollection	Represents a collection of SqlSearchPropertyPair elements.
	SqlSecurityPolicyPair	Represents a pair of xSQL.Schema.SqlServer.SqlSecurityPolicy security policies.
	SqlSecurityPolicyPairCollection	Represents a collection of SqlSecurityPolicyPair entities.
	SqlSecurityPolicyPairEventArgs	Provides data to the event raised during the comparison of the security policies.
	SqlSecurityPredicatePair	Represents a pair of xSQL.Schema.SqlServer.SqlSecurityPredicate objects.
	SqlSecurityPredicatePairCollection	Represents a collection of SqlSecurityPredicatePair elements.
	SqlSequencePair	Represents a pair of xSQL.Schema.SqlServer.SqlSequence objects.
	SqlSequencePairCollection	Represents a collection of SqlSequencePair entities.
	SqlSequencePairEventArgs	Provides data to the event raised during the comparison of sequences.
	SqlSpatialIndexPair	Represents a pair of xSQL.Schema.SqlServer.SqlSpatialIndex objects.
	SqlSpatialIndexPairCollection	Represents a collection of SqlSpatialIndexPair entities.
	SqlSpatialIndexPairEventArgs	Provides data to the event raised during the comparison of spatial indexes.
	SqlStatisticPair	Represents a pair of xSQL.Schema.SqlServer.SqlStatistic objects.
	SqlStatisticPairCollection	Represents a collection of SqlStatisticPair entities.
	SqlStatisticPairEventArgs	Provides data to the event raised during the comparison of statistics.
	SqlSymmetricKeyPair	Represents a pair of xSQL.Schema.SqlServer.SqlSymmetricKey objects.
	SqlSymmetricKeyPairCollection	Represents a collection of SqlSymmetricKeyPair entities.
	SqlSymmetricKeyPairEventArgs	Provides data to the event raised during the comparison of symmetric keys.
	SqlSynonymPair	Represents a pair of xSQL.Schema.SqlServer.SqlSynonym objects.
	SqlSynonymPairCollection	Represents a collection of SqlSynonymPair entities.
	SqlSynonymPairEventArgs	Provides data to the event raised during the comparison of synonyms.
	SqlTablePair	Represents a pair of xSQL.Schema.SqlServer.SqlTable objects.
	SqlTablePairCollection	Represents a collection of SqlTablePair entities.
	SqlTablePairEventArgs	Provides data to the event raised during the comparison of tables.
	SqlTriggerPair	Represents a pair of xSQL.Schema.SqlServer.SqlTrigger objects.
	SqlTriggerPairCollection	Represents a collection of SqlTriggerPair entities.
	SqlTriggerPairEventArgs	Provides data to the event raised during the comparison of triggers.
	SqlUniqueConstraintPair	Represents a pair of xSQL.Schema.SqlServer.SqlUniqueConstraint objects.
	SqlUniqueConstraintPairCollection	Represents a collection of SqlUniqueConstraintPair entities.
	SqlUniqueConstraintPairEventArgs	Provides data to the event raised during the comparison of unique constraints.
	SqlUserDefinedDataTypePair	Represents a pair of xSQL.Schema.SqlServer.SqlUserDefinedDataType objects.
	SqlUserDefinedDataTypePairCollection	Represents a collection of SqlUserDefinedDataTypePair entities.
	SqlUserDefinedDataTypePairEventArgs	Provides data to the event raised during the comparison of user-defined data types.
	SqlUserDefinedTableTypePair	Represents a pair of xSQL.Schema.SqlServer.SqlUserDefinedTableType objects.
	SqlUserDefinedTableTypePairCollection	Represents a collection of SqlUserDefinedTableTypePair entities.
	SqlUserDefinedTableTypePairEventArgs	Provides data to the event raised during the comparison of user-defined table types.
	SqlUserPair	Represents a pair of xSQL.Schema.SqlServer.SqlUser of database users.
	SqlUserPairCollection	Represents a collection of SqlUserPair entities.
	SqlUserPairEventArgs	Provides data to the event raised during the comparison of database users.
	SqlViewPair	Represents a pair of xSQL.Schema.SqlServer.SqlView objects.
	SqlViewPairCollection	Represents a collection of SqlViewPair entities.
	SqlViewPairEventArgs	Provides data to the event raised during the comparison of views.
	SqlXmlIndexPair	Represents a pair of xSQL.Schema.SqlServer.SqlXmlIndex objects.
	SqlXmlIndexPairCollection	Represents a collection of SqlXmlIndexPair entities.
	SqlXmlIndexPairEventArgs	Provides data to the event raised during the comparison of xml indexes.
	SqlXmlSchemaCollectionPair	Represents a pair of xSQL.Schema.SqlServer.SqlXmlSchemaCollection objects.
	SqlXmlSchemaCollectionPairCollection	Represents a collection of SqlXmlSchemaCollectionPair entities.
	SqlXmlSchemaCollectionPairEventArgs	Provides data to the event raised during the comparison of xml schema collections.
	StopListWordPair	Represents a pair of xSQL.Schema.SqlServer.StopListWord objects associated with the full-text stop list.
	StopListWordPairCollection	Represents a collection of StopListWordPair objects.
	TableViewPairBase<T>	Provides the base class for a pair of tables or views.

Interfaces

	Interface	Description
	IExtendedPropertyPair	Represents the interface implemented by a pair of database objects that support extended properties.
	IPermissionPair	Represents the interface implemented by a pair of database objects that supports permissions.

Enumerations

	Enumeration	Description
	AssemblyCreateOptionEnum	Defines constants that determine the additional action that should be performed in a database when a new assembly is created. Changes in the assembly registration policy, introduced in SQL Server 2017, require these additional actions in order to successfully register the assembly.
	ComparisonOptionTypeEnum	Defines constants that represents the type of a comparison option.
	ComparisonStatusEnum	Defines constants that indicate the comparison status of a pair of entities.
	EntityMappingTypeEnum	Defines constants that indicate that type of mapping between database entities.
	FileGroupComparisonOptionEnum	Specifies the type of the mapping between two database filegroups.
	SchemaFilterOperatorTypeEnum	Defines the operator types for a schema filter.
	SchemaFilterTypeEnum	Defines constants the indicate the type of a schema filter conditions.
	ScriptExecutionStatusEnum	Defines constants that indicate the execution status of the schema synchronization script.

Reference

xSQL.SchemaCompare.SqlServer Assembly