DacDeployOptions 类

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

继承层次结构

System.Object
  Microsoft.SqlServer.Dac.DacDeployOptions

命名空间:  Microsoft.SqlServer.Dac
程序集:  Microsoft.SqlServer.Dac(在 Microsoft.SqlServer.Dac.dll 中)

语法

声明
Public NotInheritable Class DacDeployOptions
用法
Dim instance As DacDeployOptions
public sealed class DacDeployOptions
public ref class DacDeployOptions sealed
[<SealedAttribute>]
type DacDeployOptions =  class end
public final class DacDeployOptions

DacDeployOptions 类型公开以下成员。

构造函数

  名称 说明
公共方法 DacDeployOptions Create a new instance of the DacDeployOptions class with default options.

页首

属性

  名称 说明
公共属性 AdditionalDeploymentContributorArguments Specifies additional deployment contributor arguments in addition to those already listed in the dacpac.
公共属性 AdditionalDeploymentContributors Specifies additional deployment contributors which should run - in addition to those specified in the dacpac.
公共属性 AllowDropBlockingAssemblies Get or set boolean that specifies whether CLR deployment will cause blocking assemblies to be dropped.
公共属性 AllowIncompatiblePlatform Get or set boolean that specifies whether deployment will block due to platform compatibility.
公共属性 BackupDatabaseBeforeChanges Get or set boolean that specifies whether a database backup will be performed before proceeding with the actual deployment actions.
公共属性 BlockOnPossibleDataLoss Get or set boolean that specifies whether deployment should stop if the operation could cause data loss.
公共属性 BlockWhenDriftDetected 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.
公共属性 CommentOutSetVarDeclarations Get or set boolean that specifies whether the declaration of SQLCMD variables are commented out in the script header.
公共属性 CompareUsingTargetCollation Get or set boolean that specifies whether the source collation will be used for identifier comparison.
公共属性 CreateNewDatabase 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.
公共属性 DeployDatabaseInSingleUserMode 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.
公共属性 DisableAndReenableDdlTriggers 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.
公共属性 DoNotAlterChangeDataCaptureObjects Get or set boolean that specifies whether items configured for Change Data Capture (CDC) should be altered during deployment.
公共属性 DoNotAlterReplicatedObjects Get or set boolean that specifies whether items configured for Replication should be altered during deployment.
公共属性 DropConstraintsNotInSource Get or set boolean that specifies whether to drop all constraints that do not exist in the source model.
公共属性 DropDmlTriggersNotInSource Get or set boolean that specifies whether to drop all DML triggers that do not exist in the source model.
公共属性 DropExtendedPropertiesNotInSource Get or set boolean that specifies whether to drop all extended properties that do not exist in the source model.
公共属性 DropIndexesNotInSource Get or set boolean that specifies whether to drop all indexes that do not exist in the source model.
公共属性 DropObjectsNotInSource Get or set boolean that specifies whether objects that exist in the target but not source should be dropped during deployment.
公共属性 DropPermissionsNotInSource Get or set boolean that specifies whether to drop all permissions that do not exist in the source model.
公共属性 DropRoleMembersNotInSource Get or set boolean that specifies whether to drop all role memberships that do not exist in the source model.
公共属性 GenerateSmartDefaults Get or set boolean that specifies whether default values should be generated to populate NULL columns that are constrained to NOT NULL values.
公共属性 IgnoreAnsiNulls Get or set boolean that specifies whether to exclude the ANSI_NULL option from consideration when comparing the source and target model.
公共属性 IgnoreAuthorizer Get or set boolean that specifies whether to exclude the AUTHORIZATION option from consideration when comparing the source and target model.
公共属性 IgnoreColumnCollation Get or set boolean that specifies whether to exclude the collation specifier from consideration when comparing the source and target model.
公共属性 IgnoreComments Get or set boolean that specifies whether to exclude comments from consideration when comparing the source and target model.
公共属性 IgnoreCryptographicProviderFilePath 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.
公共属性 IgnoreDdlTriggerOrder Get or set boolean that specifies whether to exclude DDL trigger order from consideration when comparing the source and target model.
公共属性 IgnoreDdlTriggerState Get or set boolean that specifies whether to exclude DDL trigger state from consideration when comparing the source and target model.
公共属性 IgnoreDefaultSchema Get or set boolean that specifies whether to exclude the DEFAULT_SCHEMA option from consideration when comparing the source and target model.
公共属性 IgnoreDmlTriggerOrder Get or set boolean that specifies whether to exclude DML trigger order from consideration when comparing the source and target model.
公共属性 IgnoreDmlTriggerState Get or set boolean that specifies whether to exclude DML trigger state from consideration when comparing the source and target model.
公共属性 IgnoreExtendedProperties Get or set boolean that specifies whether to exclude all extended properties from consideration when comparing the source and target model.
公共属性 IgnoreFileAndLogFilePath Get or set boolean that specifies whether to exclude the FILENAME option of FILE objects from consideration when comparing the source and target model.
公共属性 IgnoreFilegroupPlacement Get or set boolean that specifies whether to exclude the filegroup specifier from consideration when comparing the source and target model.
公共属性 IgnoreFileSize Get or set boolean that specifies whether to exclude the SIZE option of FILE objects from consideration when comparing the source and target model.
公共属性 IgnoreFillFactor Get or set boolean that specifies whether to exclude the FILLFACTOR option from consideration when comparing the source and target model.
公共属性 IgnoreFullTextCatalogFilePath 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.
公共属性 IgnoreIdentitySeed Get or set boolean that specifies whether to exclude the seed value of IDENTITY columns from consideration when comparing the source and target model.
公共属性 IgnoreIncrement Get or set boolean that specifies whether to exclude the increment value of IDENTITY columns from consideration when comparing the source and target model.
公共属性 IgnoreIndexOptions Get or set boolean that specifies whether to exclude differences in index options from consideration when comparing the source and target model.
公共属性 IgnoreIndexPadding Get or set boolean that specifies whether to exclude the PAD_INDEX option from consideration when comparing the source and target model.
公共属性 IgnoreKeywordCasing Get or set boolean that specifies whether to exclude difference in the casing of keywords from consideration when comparing the source and target model.
公共属性 IgnoreLockHintsOnIndexes 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.
公共属性 IgnoreLoginSids 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.
公共属性 IgnoreNotForReplication Get or set boolean that specifies whether to exclude the NOT FOR REPLICATION option from consideration when comparing the source and target model.
公共属性 IgnoreObjectPlacementOnPartitionScheme 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.
公共属性 IgnorePartitionSchemes 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.
公共属性 IgnorePermissions Get or set boolean that specifies whether to exclude all permission statements from consideration when comparing the source and target model.
公共属性 IgnoreQuotedIdentifiers Get or set boolean that specifies whether to exclude the QUOTED_IDENTIFIER option from consideration when comparing the source and target model.
公共属性 IgnoreRoleMembership Get or set boolean that specifies whether to exclude all ROLE MEMBERSHIP objects from consideration when comparing the source and target model.
公共属性 IgnoreRouteLifetime Get or set boolean that specifies whether to exclude the LIFETIME option of ROUTE objects from consideration when comparing the source and target model.
公共属性 IgnoreSemicolonBetweenStatements 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.
公共属性 IgnoreTableOptions Get or set boolean that specifies whether the options on the target table are updated to match the source table.
公共属性 IgnoreUserSettingsObjects Get or set boolean that specifies whether to exclude user settings from consideration when comparing the source and target model.
公共属性 IgnoreWhitespace Get or set boolean that specifies whether to exclude whitespace from consideration when comparing the source and target model.
公共属性 IgnoreWithNocheckOnCheckConstraints 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.
公共属性 IgnoreWithNocheckOnForeignKeys 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.
公共属性 IncludeCompositeObjects 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.
公共属性 IncludeTransactionalScripts Get or set boolean that specifies whether to use transations during the deployment operation and commit the transaction after all changes are successfully applied.
公共属性 NoAlterStatementsToChangeClrTypes Get or set boolean that specifies whether to force a change to CLR assemblies by dropping and recreating them.
公共属性 PopulateFilesOnFileGroups Get or set boolean that specifies whether files are supplied for filegroups defined in the deployment source.
公共属性 RegisterDataTierApplication 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.
公共属性 RunDeploymentPlanExecutors Specifies whether DeploymentPlanExecutor contributors should be run when other operations are executed. Default is false.
公共属性 ScriptDatabaseCollation Get or set boolean that specifies whether the target database should be altered to match the source model's collation.
公共属性 ScriptDatabaseCompatibility Get or set boolean that specifies whether the target database should be altered to match the source model's compatibility level.
公共属性 ScriptDatabaseOptions Get or set boolean that specifies whether the database options in the target database should be updated to match the source model.
公共属性 ScriptDeployStateChecks Get or set boolean that specifies whether the target database should be checked to ensure that it exists, is online and can be updated.
公共属性 ScriptFileSize Get or set boolean that specifies whether a file size is specified when adding files to file groups.
公共属性 ScriptNewConstraintValidation Get or set boolean that specifies whether constraints are validated after all changes are applied.
公共属性 ScriptRefreshModule Get or set boolean that specifies whether referencing procedures are refreshed when referenced objects are updated.
公共属性 SqlCommandVariableValues Get dictionary of SQL command variable values, keyed by variable name.
公共属性 TreatVerificationErrorsAsWarnings Get or set boolean that specifies whether the deployment operation should proceed when errors are generated during plan verification.
公共属性 UnmodifiableObjectWarnings Get or set boolean that specifies whether the deployment operation should proceed when errors are generated during plan verification.
公共属性 VerifyCollationCompatibility 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.
公共属性 VerifyDeployment Get or set boolean that specifies whether the plan verification phase is executed or not.

页首

方法

  名称 说明
公共方法 Equals (从 Object 继承。)
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 ToString (从 Object 继承。)

页首

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Dac 命名空间