Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DacDeployOptions Class

DacDeployOptions Class

 

Defines options that affect the behavior of package deployment to a database.

Namespace:   Microsoft.SqlServer.Dac
Assembly:  Microsoft.SqlServer.Dac (in Microsoft.SqlServer.Dac.dll)

System.Object
  Microsoft.SqlServer.Dac.DacDeployOptions

public sealed class DacDeployOptions

NameDescription
System_CAPS_pubmethodDacDeployOptions()

Create a new instance of the DacDeployOptions class with default options.

NameDescription
System_CAPS_pubpropertyAdditionalDeploymentContributorArguments

Specifies additional deployment contributor arguments in addition to those already listed in the dacpac.

System_CAPS_pubpropertyAdditionalDeploymentContributors

Specifies additional deployment contributors which should run - in addition to those specified in the dacpac.

System_CAPS_pubpropertyAllowDropBlockingAssemblies

Get or set boolean that specifies whether CLR deployment will cause blocking assemblies to be dropped.

System_CAPS_pubpropertyAllowIncompatiblePlatform

Get or set boolean that specifies whether deployment will block due to platform compatibility.

System_CAPS_pubpropertyBackupDatabaseBeforeChanges

Get or set boolean that specifies whether a database backup will be performed before proceeding with the actual deployment actions.

System_CAPS_pubpropertyBlockOnPossibleDataLoss

Get or set boolean that specifies whether deployment should stop if the operation could cause data loss.

System_CAPS_pubpropertyBlockWhenDriftDetected

Get or set boolean that specifies whether the system will check for differences between the present state of the database and the registered state of the database and block deployment if changes are detected. Even if this option is set to true, drift detection will only occur on a database if it was previously deployed with the RegisterDataTierApplication option enabled.

System_CAPS_pubpropertyCommandTimeout

Specifies the command timeout in seconds when executing queries against SQLServer.

System_CAPS_pubpropertyCommentOutSetVarDeclarations

Get or set boolean that specifies whether the declaration of SQLCMD variables are commented out in the script header.

System_CAPS_pubpropertyCompareUsingTargetCollation

Get or set boolean that specifies whether the source collation will be used for identifier comparison.

System_CAPS_pubpropertyCreateNewDatabase

Get or set boolean that specifies whether the existing database will be dropped and a new database created before proceeding with the actual deployment actions. Acquires single-user mode before dropping the existing database.

System_CAPS_pubpropertyDeployDatabaseInSingleUserMode

Get or set boolean that specifies whether the system will acquire single-user mode on the target database during the duration of the deployment operation.

System_CAPS_pubpropertyDisableAndReenableDdlTriggers

Get or set boolean that specifies if all DDL triggers will be disabled for the duration of the deployment operation and then re-enabled after all changes are applied.

System_CAPS_pubpropertyDoNotAlterChangeDataCaptureObjects

Get or set boolean that specifies whether items configured for Change Data Capture (CDC) should be altered during deployment.

System_CAPS_pubpropertyDoNotAlterReplicatedObjects

Get or set boolean that specifies whether items configured for Replication should be altered during deployment.

System_CAPS_pubpropertyDropConstraintsNotInSource

Get or set boolean that specifies whether to drop all constraints that do not exist in the source model.

System_CAPS_pubpropertyDropDmlTriggersNotInSource

Get or set boolean that specifies whether to drop all DML triggers that do not exist in the source model.

System_CAPS_pubpropertyDropExtendedPropertiesNotInSource

Get or set boolean that specifies whether to drop all extended properties that do not exist in the source model.

System_CAPS_pubpropertyDropIndexesNotInSource

Get or set boolean that specifies whether to drop all indexes that do not exist in the source model.

System_CAPS_pubpropertyDropObjectsNotInSource

Get or set boolean that specifies whether objects that exist in the target but not source should be dropped during deployment.

System_CAPS_pubpropertyDropPermissionsNotInSource

Get or set boolean that specifies whether to drop all permissions that do not exist in the source model.

System_CAPS_pubpropertyDropRoleMembersNotInSource

Get or set boolean that specifies whether to drop all role memberships that do not exist in the source model.

System_CAPS_pubpropertyDropStatisticsNotInSource

Get or set boolean that specifies whether to drop all role memberships that do not exist in the source model.

System_CAPS_pubpropertyGenerateSmartDefaults

Get or set boolean that specifies whether default values should be generated to populate NULL columns that are constrained to NOT NULL values.

System_CAPS_pubpropertyIgnoreAnsiNulls

Get or set boolean that specifies whether to exclude the ANSI_NULL option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreAuthorizer

Get or set boolean that specifies whether to exclude the AUTHORIZATION option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreColumnCollation

Get or set boolean that specifies whether to exclude the collation specifier from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreComments

Get or set boolean that specifies whether to exclude comments from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreCryptographicProviderFilePath

Get or set boolean that specifies whether to exclude the file specification of a cryptographic provider from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreDdlTriggerOrder

Get or set boolean that specifies whether to exclude DDL trigger order from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreDdlTriggerState

Get or set boolean that specifies whether to exclude DDL trigger state from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreDefaultSchema

Get or set boolean that specifies whether to exclude the DEFAULT_SCHEMA option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreDmlTriggerOrder

Get or set boolean that specifies whether to exclude DML trigger order from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreDmlTriggerState

Get or set boolean that specifies whether to exclude DML trigger state from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreExtendedProperties

Get or set boolean that specifies whether to exclude all extended properties from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreFileAndLogFilePath

Get or set boolean that specifies whether to exclude the FILENAME option of FILE objects from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreFilegroupPlacement

Get or set boolean that specifies whether to exclude the filegroup specifier from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreFileSize

Get or set boolean that specifies whether to exclude the SIZE option of FILE objects from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreFillFactor

Get or set boolean that specifies whether to exclude the FILLFACTOR option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreFullTextCatalogFilePath

Get or set boolean that specifies whether to exclude the path specification of FULLTEXT CATALOG objects from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreIdentitySeed

Get or set boolean that specifies whether to exclude the seed value of IDENTITY columns from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreIncrement

Get or set boolean that specifies whether to exclude the increment value of IDENTITY columns from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreIndexOptions

Get or set boolean that specifies whether to exclude differences in index options from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreIndexPadding

Get or set boolean that specifies whether to exclude the PAD_INDEX option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreKeywordCasing

Get or set boolean that specifies whether to exclude difference in the casing of keywords from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreLockHintsOnIndexes

Get or set boolean that specifies whether to exclude the ALLOW_ROW_LOCKS and ALLOW_PAGE_LOGKS options from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreLoginSids

Get or set boolean that specifies whether to exclude the SID option of the LOGIN object from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreNotForReplication

Get or set boolean that specifies whether to exclude the NOT FOR REPLICATION option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreObjectPlacementOnPartitionScheme

Get or set boolean that specifies whether to exclude the partition scheme object from consideration when comparing the source and target model for the following objects: Table, Index, Unique Key, Primary Key, and Queue.

System_CAPS_pubpropertyIgnorePartitionSchemes

Get or set boolean that specifies whether to exclude the parameter type and boundary VALUES of a PARTITION FUNCTION from consideration when comparing the source and target model. Also excludes FILEGROUP and partition function of a PARTITION SCHEMA from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnorePermissions

Get or set boolean that specifies whether to exclude all permission statements from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreQuotedIdentifiers

Get or set boolean that specifies whether to exclude the QUOTED_IDENTIFIER option from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreRoleMembership

Get or set boolean that specifies whether to exclude all ROLE MEMBERSHIP objects from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreRouteLifetime

Get or set boolean that specifies whether to exclude the LIFETIME option of ROUTE objects from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreSemicolonBetweenStatements

Get or set boolean that specifies whether to exclude the existence or absence of semi-colons from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreTableOptions

Get or set boolean that specifies whether the options on the target table are updated to match the source table.

System_CAPS_pubpropertyIgnoreUserSettingsObjects

Get or set boolean that specifies whether to exclude user settings from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreWhitespace

Get or set boolean that specifies whether to exclude whitespace from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreWithNocheckOnCheckConstraints

Get or set boolean that specifies whether to exclude the CHECK|NO CHECK option of a CHECK constraint object from consideration when comparing the source and target model.

System_CAPS_pubpropertyIgnoreWithNocheckOnForeignKeys

Get or set boolean that specifies whether to exclude the CHECK|NO CHECK option of a FOREIGN KEY constraint object from consideration when comparing the source and target model.

System_CAPS_pubpropertyIncludeCompositeObjects

Get or set boolean that specifies whether to include referenced, external elements that also compose the source model and then update the target database in a single deployment operation.

System_CAPS_pubpropertyIncludeTransactionalScripts

Get or set boolean that specifies whether to use transations during the deployment operation and commit the transaction after all changes are successfully applied.

System_CAPS_pubpropertyNoAlterStatementsToChangeClrTypes

Get or set boolean that specifies whether to force a change to CLR assemblies by dropping and recreating them.

System_CAPS_pubpropertyPopulateFilesOnFileGroups

Get or set boolean that specifies whether files are supplied for filegroups defined in the deployment source.

System_CAPS_pubpropertyRegisterDataTierApplication

Get or set boolean that specifies whether the database will be registered as a Data-Tier Application. If the target database is already a registered Data-Tier Application, then the registration will be updated.

System_CAPS_pubpropertyRunDeploymentPlanExecutors

Specifies whether DeploymentPlanExecutor contributors should be run when other operations are executed. Default is false.

System_CAPS_pubpropertyScriptDatabaseCollation

Get or set boolean that specifies whether the target database should be altered to match the source model's collation.

System_CAPS_pubpropertyScriptDatabaseCompatibility

Get or set boolean that specifies whether the target database should be altered to match the source model's compatibility level.

System_CAPS_pubpropertyScriptDatabaseOptions

Get or set boolean that specifies whether the database options in the target database should be updated to match the source model.

System_CAPS_pubpropertyScriptDeployStateChecks

Get or set boolean that specifies whether the target database should be checked to ensure that it exists, is online and can be updated.

System_CAPS_pubpropertyScriptFileSize

Get or set boolean that specifies whether a file size is specified when adding files to file groups.

System_CAPS_pubpropertyScriptNewConstraintValidation

Get or set boolean that specifies whether constraints are validated after all changes are applied.

System_CAPS_pubpropertyScriptRefreshModule

Get or set boolean that specifies whether referencing procedures are refreshed when referenced objects are updated.

System_CAPS_pubpropertySqlCommandVariableValues

Get dictionary of SQL command variable values, keyed by variable name.

System_CAPS_pubpropertyTreatVerificationErrorsAsWarnings

Get or set boolean that specifies whether the deployment operation should proceed when errors are generated during plan verification.

System_CAPS_pubpropertyUnmodifiableObjectWarnings

Get or set boolean that specifies whether the deployment operation should proceed when errors are generated during plan verification.

System_CAPS_pubpropertyVerifyCollationCompatibility

Get or set boolean that specifies whether deployment will verify that the collation specified in the source model is compatible with the collation specified in the target model.

System_CAPS_pubpropertyVerifyDeployment

Get or set boolean that specifies whether the plan verification phase is executed or not.

NameDescription
System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top

Community Additions

ADD
Show:
© 2015 Microsoft