SqlPublishTask SqlPublishTask SqlPublishTask Class

Definition

public sealed class SqlPublishTask : Microsoft.Data.Tools.Schema.Tasks.Sql.SqlDeploymentTask
type SqlPublishTask = class
    inherit SqlDeploymentTask
Public NotInheritable Class SqlPublishTask
Inherits SqlDeploymentTask
Inheritance

Constructors

SqlPublishTask() SqlPublishTask() SqlPublishTask()

Properties

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

Methods

Execute() Execute() Execute()

Events

Canceled Canceled Canceled Inherited from DataTask

Explicit Interface Implementations

ICancelableTask.Cancel() ICancelableTask.Cancel() ICancelableTask.Cancel() Inherited from DataTask

Applies to