SchemaComparisonResult SchemaComparisonResult SchemaComparisonResult Class

Definition

Class that provides information about the differences between a source and target database. Differences are represented in a tree structure.

public sealed class SchemaComparisonResult
type SchemaComparisonResult = class
Public NotInheritable Class SchemaComparisonResult
Inheritance
SchemaComparisonResultSchemaComparisonResultSchemaComparisonResult

Properties

Differences Differences Differences

A tree that contains results of schema comparison of source and target endpoints.

IsEqual IsEqual IsEqual

Indicates whether the source and target endpoints are equal

IsValid IsValid IsValid

Indicates whether comparison resulted in a valid, usable result

SourceModel SourceModel SourceModel

The source database model

TargetModel TargetModel TargetModel

The target database model

Methods

Exclude(SchemaDifference) Exclude(SchemaDifference) Exclude(SchemaDifference)

Used to try to exclude a difference as part of the set of update actions that are scripted or published.

GenerateScript(String) GenerateScript(String) GenerateScript(String)

Generates a T-SQL update script that makes the target schema consistent with the source schema.

GetErrors() GetErrors() GetErrors()

Provides an enumeration of errors that prevent successful schema compare operations.

Include(SchemaDifference) Include(SchemaDifference) Include(SchemaDifference)

Used to try to include a difference as part of the set of update actions that are scripted or published.

PublishChangesToTarget() PublishChangesToTarget() PublishChangesToTarget()

Generates and then executes a T-SQL update script that makes the target schema consistent with the source schema.

Applies to