共用方式為


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
AllowExternalLanguagePaths
AllowExternalLibraryPaths
AllowIncompatiblePlatform
AllowTableRecreation
AllowUnsafeRowLevelSecurityDataMovement
BackupDatabaseBeforeChanges
BlockOnPossibleDataLoss
BlockWhenDriftDetected
CommentOutSetVarDeclarations
CompareUsingTargetCollation
CreateNewDatabase
DacFx_Telemetry_Enabled (Inherited from DataTask)
Deploy
DeployDatabaseInSingleUserMode
DisableAndReenableDdlTriggers
DisableIndexesForDataPhase
DisableParallelismForEnablingIndexes
DoNotAlterChangeDataCaptureObjects
DoNotAlterReplicatedObjects
DoNotDropAggregates
DoNotDropApplicationRoles
DoNotDropAssemblies
DoNotDropAsymmetricKeys
DoNotDropAudits
DoNotDropBrokerPriorities
DoNotDropCertificates
DoNotDropClrUserDefinedTypes
DoNotDropColumnEncryptionKeys
DoNotDropColumnMasterKeys
DoNotDropContracts
DoNotDropCredentials
DoNotDropCryptographicProviders
DoNotDropDatabaseAuditSpecifications
DoNotDropDatabaseRoles
DoNotDropDatabaseScopedCredentials
DoNotDropDatabaseTriggers
DoNotDropDatabaseWorkloadGroups
DoNotDropDefaults
DoNotDropEndpoints
DoNotDropErrorMessages
DoNotDropEventNotifications
DoNotDropEventSessions
DoNotDropExtendedProperties
DoNotDropExternalDataSources
DoNotDropExternalFileFormats
DoNotDropExternalLanguages
DoNotDropExternalLibraries
DoNotDropExternalStreamingJobs
DoNotDropExternalStreams
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
DoNotDropWorkloadClassifiers
DoNotDropXmlSchemaCollections
DoNotEvaluateSqlCmdVariables
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
ExcludeExternalLanguages
ExcludeExternalLibraries
ExcludeExternalStreamingJobs
ExcludeExternalStreams
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
HashObjectNamesInLogs
IgnoreAnsiNulls
IgnoreAuthorizer
IgnoreColumnCollation
IgnoreColumnOrder
IgnoreComments
IgnoreCryptographicProviderFilePath
IgnoreDatabaseWorkloadGroups
IgnoreDdlTriggerOrder
IgnoreDdlTriggerState
IgnoreDefaultSchema
IgnoreDmlTriggerOrder
IgnoreDmlTriggerState
IgnoreExtendedProperties
IgnoreFileAndLogFilePath
IgnoreFilegroupPlacement
IgnoreFileSize
IgnoreFillFactor
IgnoreFullTextCatalogFilePath
IgnoreIdentitySeed
IgnoreIncrement
IgnoreIndexesStatisticsOnEnclaveEnabledColumns
IgnoreIndexOptions
IgnoreIndexPadding
IgnoreKeywordCasing
IgnoreLockHintsOnIndexes
IgnoreLoginSids
IgnoreNotForReplication
IgnoreObjectPlacementOnPartitionScheme
IgnorePartitionSchemes
IgnorePermissions
IgnorePropertyFileNameValue
IgnoreQuotedIdentifiers
IgnoreRoleMembership
IgnoreRouteLifetime
IgnoreSemicolonBetweenStatements
IgnoreSensitivityClassifications
IgnoreTableOptions
IgnoreTablePartitionOptions
IgnoreUserSettingsObjects
IgnoreWhitespace
IgnoreWithNocheckOnCheckConstraints
IgnoreWithNocheckOnForeignKeys
IgnoreWorkloadClassifiers
IncludeCompositeObjects
IncludeTransactionalScripts
IsAlwaysEncryptedParameterizationEnabled
IsCanceled (Inherited from DataTask)
NoAlterStatementsToChangeCLRTypes
OnlyTopLevelItems
OutputInclusionState
OutputOrdering
OutputPath
OutputRefactoring
PerformIndexOperationsOnline
PopulateFilesOnFileGroups
PreserveIdentityLastValues
RebuildIndexesOfflineForDataPhase
RegisterDataTierApplication
RestoreSequenceCurrentValue
SchemaCompareCategory
ScriptDatabaseCollation
ScriptDatabaseCompatibility
ScriptDatabaseOptions
ScriptDeployStateChecks
ScriptFileSize
ScriptNewConstraintValidation
ScriptRefreshModule
SelectedObjectsFilePath
ShowEqualObjects
ShowUndeployableObjects
Source
SqlScmpFilePath
SqlTasksDllPath (Inherited from DataTask)
Target
TargetDatabaseName
TaskName
TaskName (Inherited from DataTask)
TextOutput
Timeout
TreatVerificationErrorsAsWarnings
UnmodifiableObjectWarnings
VerifyCollationCompatibility
VerifyDeployment
XmlOutput
XsdPath

Methods

AfterExecute(Boolean) (Inherited from DataTask)
BeforeExecute() (Inherited from DataTask)
Execute()
Execute() (Inherited from DataTask)
ExecuteTask()
ExecuteTask() (Inherited from DataTask)

Events

Canceled (Inherited from DataTask)

Explicit Interface Implementations

ICancelableTask.Cancel() (Inherited from DataTask)

Applies to