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
AllowIncompatiblePlatform
AllowSnapshotIsolation
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
DacVersion
DatabaseAccess
DatabaseChaining
DatabaseDefaultFulltextLanguage
DatabaseDefaultLanguage
DatabaseName
DatabaseSchemaProviderName
DatabaseState
DateCorrelationOptimizationOn
DbScopedConfigLegacyCardinalityEstimation
DbScopedConfigLegacyCardinalityEstimationSecondary
DbScopedConfigMaxDOP
DbScopedConfigMaxDOPSecondary
DbScopedConfigOptimizerHotfixes
DbScopedConfigOptimizerHotfixesSecondary
DbScopedConfigParameterSniffing
DbScopedConfigParameterSniffingSecondary
DefaultCollation
DefaultCursor
DefaultFilegroup
DefaultFileStreamFilegroup
DefaultSchema
DelayedDurability
DeployDatabaseInSingleUserMode
DeploymentContributors
DeploymentExtensionConfiguration
DeploymentScriptName
DeployToDatabase
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
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
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
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
IgnoreQuotedIdentifiers
IgnoreRoleMembership
IgnoreRouteLifetime
IgnoreSemicolonBetweenStatements
IgnoreTableOptions
IgnoreTablePartitionOptions
IgnoreUserSettingsObjects
IgnoreWhitespace
IgnoreWithNocheckOnCheckConstraints
IgnoreWithNocheckOnForeignKeys
ImplicitDllAssemblyName
ImplicitDllAssemblyOwner
ImplicitDllFileName
ImplicitDllGenerateSqlClrDdl
ImplicitDllIsVisible
ImplicitDllPermissionSet
ImplicitDllSymbolsFileName
IncludeCompositeObjects
IncludeTransactionalScripts
IntermediateDirectory
IntermediateFileWrites
IsBrokerPriorityHonored
IsCanceled (Inherited from DataTask)
IsChangeTrackingAutoCleanupOn
IsChangeTrackingOn
IsEncryptionOn
IsNestedTriggersOn
IsTransformNoiseWordsOn
MemoryOptimizedElevateToSnapshot
ModelCollation
NoAlterStatementsToChangeCLRTypes
NonTransactedFileStreamAccess
NumericRoundAbort
OutputDirectory
PageVerify
Parameterization
PopulateFilesOnFileGroups
PostdeployItem
PredeployItem
PreserveHeaderComments
QueryStoreCaptureMode
QueryStoreDesiredState
QueryStoreFlushInterval
QueryStoreMaxPlansPerQuery
QueryStoreMaxStorageSize
QueryStoreStaleQueryThreshold
QueryStoreStatsInterval
QuotedIdentifier
ReadCommittedSnapshot
Recovery
RecursiveTriggersEnabled
RefactorLog
RegisterDataTierApplication
ScriptDatabaseCollation
ScriptDatabaseCompatibility
ScriptDatabaseOptions
ScriptDeployStateChecks
ScriptFileSize
ScriptNewConstraintValidation
ScriptRefreshModule
ServiceBrokerOption
Source
SqlCmdVariables
SqlReferencePath
SqlTarget
SupplementalLoggingOn
SuppressTSqlWarnings
TargetDatabaseName
TargetRecoveryTimePeriod
TargetRecoveryTimeUnit
TemporalHistoryRetentionEnabled
TornPageDetection
TreatTSqlWarningsAsErrors
TreatVerificationErrorsAsWarnings
Trustworthy
TwoDigitYearCutoff
UnmodifiableObjectWarnings
UpdateOptions
ValidateCasingOnIdentifiers
VardecimalStorageFormatOn
VerifyCollationCompatibility
VerifyDeployment

Methods

Execute()

Events

Canceled (Inherited from DataTask)

Explicit Interface Implementations

ICancelableTask.Cancel() (Inherited from DataTask)

Applies to