SqlDeployTask Class

Reference

Definition

Namespace:: Microsoft.Data.Tools.Schema.Tasks.Sql

Assembly:: Microsoft.Data.Tools.Schema.Tasks.Sql.dll

Package:: Microsoft.SqlServer.DacFx v160.6161.0

Package:: Microsoft.SqlServer.DacFx v162.2.111

Package:: Microsoft.Data.Tools.Msbuild v10.0.61804.210

Package:: Microsoft.Data.Tools.Msbuild v16.0.62004.28040

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.

public class SqlDeployTask : Microsoft.Data.Tools.Schema.Tasks.Sql.SqlDeploymentTask

type SqlDeployTask = class
    inherit SqlDeploymentTask

Public Class SqlDeployTask
Inherits SqlDeploymentTask

Inheritance: Task

DataTask

SqlDeploymentTask
SqlDeployTask

Constructors

SqlDeployTask()

Properties

AdditionalDeploymentContributorArguments
AdditionalDeploymentContributors
AllowDropBlockingAssemblies
AllowExternalLanguagePaths
AllowExternalLibraryPaths
AllowIncompatiblePlatform
AllowTableRecreation
AllowUnsafeRowLevelSecurityDataMovement
BackupDatabaseBeforeChanges
BlockOnPossibleDataLoss
BlockWhenDriftDetected
CacheTargetModel	(Inherited from SqlDeploymentTask)
CmdLineInMemoryStorage	(Inherited from SqlDeploymentTask)
CommentOutSetVarDeclarations
CompareUsingTargetCollation
ConnectionString
CreateNewDatabase
DacFx_Telemetry_Enabled	(Inherited from DataTask)
DatabaseName
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
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
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
IgnoreQuotedIdentifiers
IgnoreRoleMembership
IgnoreRouteLifetime
IgnoreSemicolonBetweenStatements
IgnoreSensitivityClassifications
IgnoreTableOptions
IgnoreTablePartitionOptions
IgnoreUserSettingsObjects
IgnoreWhitespace
IgnoreWithNocheckOnCheckConstraints
IgnoreWithNocheckOnForeignKeys
IgnoreWorkloadClassifiers
IncludeCompositeObjects
IncludeTransactionalScripts
IsAlwaysEncryptedParameterizationEnabled
IsCanceled	(Inherited from DataTask)
NoAlterStatementsToChangeCLRTypes
PerformIndexOperationsOnline
PopulateFilesOnFileGroups
PreserveIdentityLastValues
RebuildIndexesOfflineForDataPhase
RegisterDataTierApplication
RestoreSequenceCurrentValue
ScriptDatabaseCollation
ScriptDatabaseCompatibility
ScriptDatabaseOptions
ScriptDeployStateChecks
ScriptFile	(Inherited from SqlDeploymentTask)
ScriptFileSize
ScriptNewConstraintValidation
ScriptRefreshModule
SourceModel	(Inherited from SqlDeploymentTask)
SqlCommandVariableOverrides
SqlTasksDllPath	(Inherited from DataTask)
TargetDatabaseName
TaskName	(Inherited from SqlDeploymentTask)
TreatVerificationErrorsAsWarnings
UnmodifiableObjectWarnings
UpdateDatabase	(Inherited from SqlDeploymentTask)
VerifyCollationCompatibility
VerifyDeployment

Methods

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

Events

Canceled

(Inherited from DataTask)

Explicit Interface Implementations

ICancelableTask.Cancel()