SchemaComparisonResult Class

Definition

Namespace:

Microsoft.SqlServer.Dac.Compare

Assembly:

Microsoft.SqlServer.Dac.Extensions.dll

Package:

Microsoft.SqlServer.DacFx v162.2.111

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

Object

SchemaComparisonResult

Properties

Differences	A tree that contains results of schema comparison of source and target endpoints.
IsEqual	Indicates whether the source and target endpoints are equal
IsValid	Indicates whether comparison resulted in a valid, usable result
SourceModel	The source database model
TargetModel	The target database model

Methods

Exclude(SchemaDifference)	Used to try to exclude a difference as part of the set of update actions that are scripted or published.
GenerateScript(String)	Generates a T-SQL update script that makes the target schema consistent with the source schema.
GenerateScript(String, CancellationToken)	Generates a T-SQL update script that makes the target schema consistent with the source schema.
GetDiffEntrySourceScript(SchemaDifference)	Gets the source script for the SchemaDifference from the SchemaComparisonResult, if there is one. SchemaDifferences with "Delete" as the SchemaUpdateAction do not have a source script.
GetDiffEntryTargetScript(SchemaDifference)	Gets the target script for the SchemaDifference from the SchemaComparisonResult, if there is one. SchemaDifferences with "Add" as the SchemaUpdateAction do not have a target script.
GetErrors()	Provides an enumeration of errors that prevent successful schema compare operations.
GetExcludeDependencies(SchemaDifference)	Get Dependencies to cost Exclude operation on a node
GetIncludeDependencies(SchemaDifference)	Get Dependencies to cost Include operation on a node
Include(SchemaDifference)	Used to try to include a difference as part of the set of update actions that are scripted or published.
PublishChangesToDatabase()	Generates and then executes a T-SQL update script that makes the target database schema consistent with the source schema.
PublishChangesToDatabase(CancellationToken)	Generates and then executes a T-SQL update script that makes the target database schema consistent with the source schema.
PublishChangesToProject(String, DacExtractTarget)	Updates the target project schema to be consistent with the source schema
PublishChangesToTarget()	Obsolete. Generates and then executes a T-SQL update script that makes the target schema consistent with the source schema.
PublishChangesToTarget(CancellationToken)	Obsolete. Generates and then executes a T-SQL update script that makes the target schema consistent with the source schema.