SchemaComparison Class

Definition

Class that allows comparing schema between two types of entities: databases and dacpac files

public sealed class SchemaComparison
type SchemaComparison = class
Public NotInheritable Class SchemaComparison
Inheritance
SchemaComparison

Constructors

SchemaComparison(SchemaCompareEndpoint, SchemaCompareEndpoint)

SchemaComparison constructor that takes endpoints that specify the source and target for comparison.

SchemaComparison(String)

SchemaComparison constructor that uses a schema compare file (.scmp file) for all comparison settings. Only dacpac and/or database endpoints may be compared.

Properties

ExcludedSourceObjects

Elements in the source database model to exclude from comparison.

ExcludedTargetObjects

Elements in the target database model to exclude from comparison.

Options

Options that affect the behavior of package deployment.

Source

The SchemaCompareEndpoint that refers to a schema source.

Target

The SchemaCompareEndpoint that refers to a target. Comparison will update the target to match the source.

Methods

Compare()

Performs schema comparison, populating comparison results.

Compare(CancellationToken)

Performs schema comparison, populating comparison results.

SaveToFile(String, Boolean)

Saves the SchemaComparison as an scmp file.

SaveToStream(Stream)

Saves the SchemaComparison as an scmp file into a stream

Applies to