SqlModelComparerConfiguration Class

  • Article

Comparison configuration information for comparison models of two SQL Server databases.

Inheritance Hierarchy

System.Object
  Microsoft.Data.Schema.SchemaModel.ModelComparerConfiguration
    Microsoft.Data.Schema.Sql.SchemaModel.SqlModelComparerConfiguration

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Class SqlModelComparerConfiguration _
    Inherits ModelComparerConfiguration

public class SqlModelComparerConfiguration : ModelComparerConfiguration

public ref class SqlModelComparerConfiguration : public ModelComparerConfiguration

type SqlModelComparerConfiguration =  
    class
        inherit ModelComparerConfiguration
    end

public class SqlModelComparerConfiguration extends ModelComparerConfiguration

The SqlModelComparerConfiguration type exposes the following members.

Constructors

  Name Description
Public method SqlModelComparerConfiguration() Initializes a new instance of the SqlModelComparerConfiguration class.
Public method SqlModelComparerConfiguration(ModelComparisonFilter) Initializes a new instance of the SqlModelComparerConfiguration class.
Public method SqlModelComparerConfiguration(ModelComparisonFilter, Boolean, Boolean) Initializes a new instance of the SqlModelComparerConfiguration class.

Top

Properties

  Name Description
Public property DefaultSchemaForSource Gets or sets the default schema in the source model that is used to set default schema, if that relationship is not set.
Public property DefaultSchemaForTarget Gets or sets the default schema in the target model that is used to set default schema, if that relationship is not set.
Public property DefaultUserForSource Gets or sets the default user in the source model that is used to set the default authorizer or default user, if that relationship is not set.
Public property DefaultUserForTarget Gets or sets the default user in the target model that is used to set the default authorizer or default user, if that relationship is not set.
Public property Filter Gets or sets the filter that is defined for this comparison configuration. (Inherited from ModelComparerConfiguration.)
Public property IgnoreColumnOrder Gets or sets a value that indicates whether to ignore differences in column order.
Public property IgnoreComments Gets or sets a value that indicates whether to ignore any comments inside body script.
Public property IgnoreKeywordCasing Gets or sets a value that indicates whether to ignore any keyword casing when models are compared.
Public property IgnoreSemicolonBetweenStatements Gets or sets a value that indicates whether to ignore any semicolons between statements.
Public property IgnoreWhiteSpace Gets or sets a value that indicates whether to ignore any white space inside body script.
Public property OnlyCompareElementsInSource Gets or sets a value that indicates whether to compare only elements that occur in the source. (Inherited from ModelComparerConfiguration.)
Public property SourceSqlCmdVariables Gets the SQLCMD variables for the source model store.
Public property TargetSqlCmdVariables Gets the SQLCMD variables for the target model store.
Public property UseSourceCollation Gets or sets a value that indicates whether to use source collation during identifier comparison. (Inherited from ModelComparerConfiguration.)

Top

Methods

  Name Description
Public method AddOrUpdateSqlCmdVariable Adds or updates a SQLCMD variable.
Public method AddPropertyValueSubstitution (Inherited from ModelComparerConfiguration.)
Public method Clone Creates a copy of a configuration. (Overrides ModelComparerConfiguration.Clone().)
Protected method CloneMemberValues Creates a copy of the specified ModelComparerConfiguration. (Overrides ModelComparerConfiguration.CloneMemberValues(ModelComparerConfiguration).)
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method RemoveSqlCmdVariable Removes a SQLCMD variable.
Public method ResetDefaultValues Cleans up any special default values that are session-based and that cannot be obtained from the model, such as the default schema or default user.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Public method TryGetPropertyValueSubstitution (Inherited from ModelComparerConfiguration.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace