SchemaComparisonResult Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Class that provides information about the differences between a source and target database. Differences are represented in a tree structure.
public sealed class SchemaComparisonResulttype SchemaComparisonResult = classPublic NotInheritable Class SchemaComparisonResult- Inheritance
-
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, CancellationToken) |
Generates a T-SQL update script that makes the target schema consistent with the source schema. |
| GenerateScript(String) |
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. |