Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | |
---|---|---|
![]() |
SqlModelComparerConfiguration() | Initializes a new instance of the SqlModelComparerConfiguration class. |
![]() |
SqlModelComparerConfiguration(ModelComparisonFilter) | Initializes a new instance of the SqlModelComparerConfiguration class. |
![]() |
SqlModelComparerConfiguration(ModelComparisonFilter, Boolean, Boolean) | Initializes a new instance of the SqlModelComparerConfiguration class. |
Top
Properties
Name | Description | |
---|---|---|
![]() |
DefaultSchemaForSource | Gets or sets the default schema in the source model that is used to set default schema, if that relationship is not set. |
![]() |
DefaultSchemaForTarget | Gets or sets the default schema in the target model that is used to set default schema, if that relationship is not set. |
![]() |
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. |
![]() |
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. |
![]() |
Filter | Gets or sets the filter that is defined for this comparison configuration. (Inherited from ModelComparerConfiguration.) |
![]() |
IgnoreColumnOrder | Gets or sets a value that indicates whether to ignore differences in column order. |
![]() |
IgnoreComments | Gets or sets a value that indicates whether to ignore any comments inside body script. |
![]() |
IgnoreKeywordCasing | Gets or sets a value that indicates whether to ignore any keyword casing when models are compared. |
![]() |
IgnoreSemicolonBetweenStatements | Gets or sets a value that indicates whether to ignore any semicolons between statements. |
![]() |
IgnoreWhiteSpace | Gets or sets a value that indicates whether to ignore any white space inside body script. |
![]() |
OnlyCompareElementsInSource | Gets or sets a value that indicates whether to compare only elements that occur in the source. (Inherited from ModelComparerConfiguration.) |
![]() |
SourceSqlCmdVariables | Gets the SQLCMD variables for the source model store. |
![]() |
TargetSqlCmdVariables | Gets the SQLCMD variables for the target model store. |
![]() |
UseSourceCollation | Gets or sets a value that indicates whether to use source collation during identifier comparison. (Inherited from ModelComparerConfiguration.) |
Top
Methods
Name | Description | |
---|---|---|
![]() |
AddOrUpdateSqlCmdVariable | Adds or updates a SQLCMD variable. |
![]() |
AddPropertyValueSubstitution | (Inherited from ModelComparerConfiguration.) |
![]() |
Clone | Creates a copy of a configuration. (Overrides ModelComparerConfiguration.Clone().) |
![]() |
CloneMemberValues | Creates a copy of the specified ModelComparerConfiguration. (Overrides ModelComparerConfiguration.CloneMemberValues(ModelComparerConfiguration).) |
![]() |
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
![]() |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() |
GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() |
RemoveSqlCmdVariable | Removes a SQLCMD variable. |
![]() |
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. |
![]() |
ToString | Returns a string that represents the current object. (Inherited from Object.) |
![]() |
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.