SqlBuildTask Class

Definition

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

Constructors

SqlBuildTask()

Properties

AdditionalDeploymentContributorArguments
AdditionalDeploymentContributors
AllowDropBlockingAssemblies
AllowExternalLanguagePaths
AllowExternalLibraryPaths
AllowIncompatiblePlatform
AllowSnapshotIsolation
AllowTableRecreation
AllowUnsafeRowLevelSecurityDataMovement
AnsiNullDefault
AnsiNulls
AnsiPadding
AnsiWarnings
ArithAbort
AutoClose
AutoCreateStatistics
AutoCreateStatisticsIncremental
AutoShrink
AutoUpdateStatistics
AutoUpdateStatisticsAsynchronously
BackupDatabaseBeforeChanges
BlockOnPossibleDataLoss
BlockWhenDriftDetected
BuildContributors
BuildExtensionConfiguration
CatalogCollation
ChangeTrackingRetentionPeriod
ChangeTrackingRetentionUnit
CloseCursorOnCommitEnabled
CmdLineInMemoryStorage
CommentOutSetVarDeclarations
CompareUsingTargetCollation
CompatibilityMode
ConcatNullYieldsNull
ConnectionString
Containment
ContributorArguments
CreateNewDatabase
CreateScriptFileName
DacApplicationName
DacDescription
DacFile
DacFx_Telemetry_Enabled (Inherited from DataTask)
DacVersion
DatabaseAccess
DatabaseChaining
DatabaseDefaultFulltextLanguage
DatabaseDefaultLanguage
DatabaseName
DatabaseSchemaProviderName
DatabaseState
DataRetentionEnabled
DateCorrelationOptimizationOn
DbScopedConfigDWCompatibilityLevel
DbScopedConfigLegacyCardinalityEstimation
DbScopedConfigLegacyCardinalityEstimationSecondary
DbScopedConfigMaxDOP
DbScopedConfigMaxDOPSecondary
DbScopedConfigOptimizerHotfixes
DbScopedConfigOptimizerHotfixesSecondary
DbScopedConfigParameterSniffing
DbScopedConfigParameterSniffingSecondary
DefaultCollation
DefaultCursor
DefaultFilegroup
DefaultFileStreamFilegroup
DefaultSchema
DelayedDurability
DeployDatabaseInSingleUserMode
DeploymentContributors
DeploymentExtensionConfiguration
DeploymentScriptName
DeployToDatabase
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
EnableFullTextSearch
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
FileStreamDirectoryName
GenerateCreateScript
GenerateDac
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
ImplicitDllAssemblyName
ImplicitDllAssemblyOwner
ImplicitDllFileName
ImplicitDllGenerateSqlClrDdl
ImplicitDllIsVisible
ImplicitDllPermissionSet
ImplicitDllSymbolsFileName
IncludeCompositeObjects
IncludeTransactionalScripts
IntermediateDirectory
IntermediateFileWrites
IsAlwaysEncryptedParameterizationEnabled
IsBrokerPriorityHonored
IsCanceled (Inherited from DataTask)
IsChangeTrackingAutoCleanupOn
IsChangeTrackingOn
IsEncryptionOn
IsLedgerOn
IsNestedTriggersOn
IsTransformNoiseWordsOn
MemoryOptimizedElevateToSnapshot
ModelCollation
NoAlterStatementsToChangeCLRTypes
NonTransactedFileStreamAccess
NumericRoundAbort
OutputDirectory
PageVerify
Parameterization
PerformIndexOperationsOnline
PopulateFilesOnFileGroups
PostdeployItem
PredeployItem
PreserveHeaderComments
PreserveIdentityLastValues
QueryStoreCaptureMode
QueryStoreDesiredState
QueryStoreFlushInterval
QueryStoreMaxPlansPerQuery
QueryStoreMaxStorageSize
QueryStoreStaleQueryThreshold
QueryStoreStatsInterval
QuotedIdentifier
ReadCommittedSnapshot
RebuildIndexesOfflineForDataPhase
Recovery
RecursiveTriggersEnabled
RefactorLog
RegisterDataTierApplication
RestoreSequenceCurrentValue
ScriptDatabaseCollation
ScriptDatabaseCompatibility
ScriptDatabaseOptions
ScriptDeployStateChecks
ScriptFileSize
ScriptNewConstraintValidation
ScriptRefreshModule
ServiceBrokerOption
Source
SqlCmdVariables
SqlReferencePath
SqlTarget
SqlTasksDllPath (Inherited from DataTask)
SupplementalLoggingOn
SuppressTSqlWarnings
TargetDatabaseName
TargetRecoveryTimePeriod
TargetRecoveryTimeUnit
TaskName
TaskName (Inherited from DataTask)
TemporalHistoryRetentionEnabled
TornPageDetection
TreatTSqlWarningsAsErrors
TreatVerificationErrorsAsWarnings
Trustworthy
TwoDigitYearCutoff
UnmodifiableObjectWarnings
UpdateOptions
ValidateCasingOnIdentifiers
VardecimalStorageFormatOn
VerifyCollationCompatibility
VerifyDeployment

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