SqlSchemaCompareTask Class

Definition

public class SqlSchemaCompareTask : Microsoft.Data.Tools.Schema.Tasks.Sql.DataTask
type SqlSchemaCompareTask = class
    inherit DataTask
Public Class SqlSchemaCompareTask
Inherits DataTask
Inheritance
SqlSchemaCompareTask

Constructors

SqlSchemaCompareTask()

Fields

SchemaCompareCategoryName

Properties

AdditionalDeploymentContributorArguments
AdditionalDeploymentContributors
AllowDropBlockingAssemblies
AllowIncompatiblePlatform
AllowUnsafeRowLevelSecurityDataMovement
BackupDatabaseBeforeChanges
BlockOnPossibleDataLoss
BlockWhenDriftDetected
CommentOutSetVarDeclarations
CompareUsingTargetCollation
CreateNewDatabase
Deploy
DeployDatabaseInSingleUserMode
DisableAndReenableDdlTriggers
DoNotAlterChangeDataCaptureObjects
DoNotAlterReplicatedObjects
DoNotDropAggregates
DoNotDropApplicationRoles
DoNotDropAssemblies
DoNotDropAsymmetricKeys
DoNotDropAudits
DoNotDropBrokerPriorities
DoNotDropCertificates
DoNotDropClrUserDefinedTypes
DoNotDropColumnEncryptionKeys
DoNotDropColumnMasterKeys
DoNotDropContracts
DoNotDropCredentials
DoNotDropCryptographicProviders
DoNotDropDatabaseAuditSpecifications
DoNotDropDatabaseRoles
DoNotDropDatabaseScopedCredentials
DoNotDropDatabaseTriggers
DoNotDropDefaults
DoNotDropEndpoints
DoNotDropErrorMessages
DoNotDropEventNotifications
DoNotDropEventSessions
DoNotDropExtendedProperties
DoNotDropExternalDataSources
DoNotDropExternalFileFormats
DoNotDropExternalTables
DoNotDropFilegroups
DoNotDropFiles
DoNotDropFileTables
DoNotDropFullTextCatalogs
DoNotDropFullTextStoplists
DoNotDropLinkedServerLogins
DoNotDropLinkedServers
DoNotDropLogins
DoNotDropMessageTypes
DoNotDropPartitionFunctions
DoNotDropPartitionSchemes
DoNotDropPermissions
DoNotDropQueues
DoNotDropRemoteServiceBindings
DoNotDropRoleMembership
DoNotDropRoutes
DoNotDropRules
DoNotDropScalarValuedFunctions
DoNotDropSearchPropertyLists
DoNotDropSecurityPolicies
DoNotDropSequences
DoNotDropServerAuditSpecifications
DoNotDropServerRoleMembership
DoNotDropServerRoles
DoNotDropServerTriggers
DoNotDropServices
DoNotDropSignatures
DoNotDropStoredProcedures
DoNotDropSymmetricKeys
DoNotDropSynonyms
DoNotDropTables
DoNotDropTableValuedFunctions
DoNotDropUserDefinedDataTypes
DoNotDropUserDefinedTableTypes
DoNotDropUsers
DoNotDropViews
DoNotDropXmlSchemaCollections
DropConstraintsNotInSource
DropDmlTriggersNotInSource
DropExtendedPropertiesNotInSource
DropIndexesNotInSource
DropObjectsNotInSource
DropPermissionsNotInSource
DropRoleMembersNotInSource
DropStatisticsNotInSource
ExcludeAggregates
ExcludeApplicationRoles
ExcludeAssemblies
ExcludeAsymmetricKeys
ExcludeAudits
ExcludeBrokerPriorities
ExcludeCertificates
ExcludeClrUserDefinedTypes
ExcludeColumnEncryptionKeys
ExcludeColumnMasterKeys
ExcludeContracts
ExcludeCredentials
ExcludeCryptographicProviders
ExcludeDatabaseAuditSpecifications
ExcludeDatabaseRoles
ExcludeDatabaseScopedCredentials
ExcludeDatabaseTriggers
ExcludeDefaults
ExcludedTypes
ExcludeEndpoints
ExcludeErrorMessages
ExcludeEventNotifications
ExcludeEventSessions
ExcludeExternalDataSources
ExcludeExternalFileFormats
ExcludeExternalTables
ExcludeFilegroups
ExcludeFiles
ExcludeFileTables
ExcludeFullTextCatalogs
ExcludeFullTextStoplists
ExcludeLinkedServerLogins
ExcludeLinkedServers
ExcludeLogins
ExcludeMessageTypes
ExcludePartitionFunctions
ExcludePartitionSchemes
ExcludeQueues
ExcludeRemoteServiceBindings
ExcludeRoutes
ExcludeRules
ExcludeScalarValuedFunctions
ExcludeSearchPropertyLists
ExcludeSecurityPolicies
ExcludeSequences
ExcludeServerAuditSpecifications
ExcludeServerRoleMembership
ExcludeServerRoles
ExcludeServerTriggers
ExcludeServices
ExcludeSignatures
ExcludeStoredProcedures
ExcludeSymmetricKeys
ExcludeSynonyms
ExcludeTables
ExcludeTableValuedFunctions
ExcludeUserDefinedDataTypes
ExcludeUserDefinedTableTypes
ExcludeUsers
ExcludeViews
ExcludeXmlSchemaCollections
GenerateSmartDefaults
GroupBy
IgnoreAnsiNulls
IgnoreAuthorizer
IgnoreColumnCollation
IgnoreColumnOrder
IgnoreComments
IgnoreCryptographicProviderFilePath
IgnoreDdlTriggerOrder
IgnoreDdlTriggerState
IgnoreDefaultSchema
IgnoreDmlTriggerOrder
IgnoreDmlTriggerState
IgnoreExtendedProperties
IgnoreFileAndLogFilePath
IgnoreFilegroupPlacement
IgnoreFileSize
IgnoreFillFactor
IgnoreFullTextCatalogFilePath
IgnoreIdentitySeed
IgnoreIncrement
IgnoreIndexOptions
IgnoreIndexPadding
IgnoreKeywordCasing
IgnoreLockHintsOnIndexes
IgnoreLoginSids
IgnoreNotForReplication
IgnoreObjectPlacementOnPartitionScheme
IgnorePartitionSchemes
IgnorePermissions
IgnorePropertyFileNameValue
IgnoreQuotedIdentifiers
IgnoreRoleMembership
IgnoreRouteLifetime
IgnoreSemicolonBetweenStatements
IgnoreTableOptions
IgnoreTablePartitionOptions
IgnoreUserSettingsObjects
IgnoreWhitespace
IgnoreWithNocheckOnCheckConstraints
IgnoreWithNocheckOnForeignKeys
IncludeCompositeObjects
IncludeTransactionalScripts
IsCanceled (Inherited from DataTask)
NoAlterStatementsToChangeCLRTypes
OnlyTopLevelItems
OutputInclusionState
OutputOrdering
OutputPath
OutputRefactoring
PopulateFilesOnFileGroups
RegisterDataTierApplication
SchemaCompareCategory
ScriptDatabaseCollation
ScriptDatabaseCompatibility
ScriptDatabaseOptions
ScriptDeployStateChecks
ScriptFileSize
ScriptNewConstraintValidation
ScriptRefreshModule
SelectedObjectsFilePath
ShowEqualObjects
ShowUndeployableObjects
Source
SqlScmpFilePath
Target
TargetDatabaseName
TextOutput
Timeout
TreatVerificationErrorsAsWarnings
UnmodifiableObjectWarnings
VerifyCollationCompatibility
VerifyDeployment
XmlOutput
XsdPath

Methods

Execute()

Events

Canceled (Inherited from DataTask)

Explicit Interface Implementations

ICancelableTask.Cancel() (Inherited from DataTask)

Applies to