DbDacFxProvider Class

Summary

Deploy SQL database using DACFx API
Namespace
Cake.MsDeploy.Providers.MsDeployProviders
Interfaces
Base Types
graph TD Base0["MsDeployProvider"]-->Type click Base0 "/Cake.MsDeploy/api/Cake.MsDeploy.Providers/MsDeployProvider" Base1["object"]-->Base0 Interface0["IMsDeployProvider"]-.->Type click Interface0 "/Cake.MsDeploy/api/Cake.MsDeploy.Providers/IMsDeployProvider" Interface1["IMsDeployArgument"]-.->Type click Interface1 "/Cake.MsDeploy/api/Cake.MsDeploy/IMsDeployArgument" Type["DbDacFxProvider"] class Type type-node

Syntax

public class DbDacFxProvider : MsDeployProvider, IMsDeployProvider, IMsDeployArgument

Properties

Name Value Summary
AllowDropBlockingAssemblies bool?
A true or false value for the 'AllowDropBlockingAssemblies' setting.
AllowIncompatiblePlatform bool?
A true or false value for the 'AllowIncompatiblePlatform' setting.
AppendQuotesToPath bool
Determines if the Path is surrounded in "quotes"
Inherited from MsDeployProvider
AuthenticationType AuthenticationScheme?
Authentication scheme to use. NTLM is the default setting. If the wmsvc option is specified, then Basic is the default setting.
Inherited from MsDeployProvider
BackupDatabaseBeforeChanges bool?
A true or false value for the 'BackupDatabaseBeforeChanges' setting.
BlockOnPossibleDataLoss bool?
A true or false value for the 'BlockOnPossibleDataLoss' setting.
BlockWhenDriftDetected bool?
A true or false value for the 'BlockWhenDriftDetected' setting.
CommandTimeout int?
An integer value for the 'commandTimeout' setting.
CommentOutSetVarDeclarations bool?
A true or false value for the 'CommentOutSetVarDeclarations' setting.
CompareUsingTargetCollation bool?
A true or false value for the 'CompareUsingTargetCollation' setting.
ComputerName string
Name of remote computer or proxy-URL
Inherited from MsDeployProvider
CreateNewDatabase bool?
A true or false value for the 'CreateNewDatabase' setting.
DacpacAction DacpacAction
A value that is one of 'Deploy, Script, Report'.
DeployDatabaseInSingleUserMode bool?
A true or false value for the 'DeployDatabaseInSingleUserMode' setting.
Direction Direction
Determines if the Provider is a source or destination
Inherited from MsDeployProvider
DisableAndReenableDdlTriggers bool?
A true or false value for the 'DisableAndReenableDdlTriggers' setting.
DoNotAlterChangeDataCaptureObjects bool?
A true or false value for the 'DoNotAlterChangeDataCaptureObjects' setting.
DoNotAlterReplicatedObjects bool?
A true or false value for the 'DoNotAlterReplicatedObjects' setting.
DropConstraintsNotInSource bool?
A true or false value for the 'DropConstraintsNotInSource' setting.
DropDestinationDatabase bool?
A true or false value for the 'dropDestinationDatabase' setting.
DropDmlTriggersNotInSource bool?
A true or false value for the 'DropDmlTriggersNotInSource' setting.
DropExtendedPropertiesNotInSource bool?
A true or false value for the 'DropExtendedPropertiesNotInSource' setting.
DropIndexesNotInSource bool?
A true or false value for the 'DropIndexesNotInSource' setting.
DropObjectsNotInSource bool?
A true or false value for the 'DropObjectsNotInSource' setting.
DropPermissionsNotInSource bool?
A true or false value for the 'DropPermissionsNotInSource' setting.
DropRoleMembersNotInSource bool?
A true or false value for the 'DropRoleMembersNotInSource' setting.
DropStatisticsNotInSource bool?
A true or false value for the 'DropStatisticsNotInSource' setting.
GenerateSmartDefaults bool?
A true or false value for the 'GenerateSmartDefaults' setting.
IgnoreAnsiNulls bool?
A true or false value for the 'IgnoreAnsiNulls' setting.
IgnoreAuthorizer bool?
A true or false value for the 'IgnoreAuthorizer' setting.
IgnoreColumnCollation bool?
A true or false value for the 'IgnoreColumnCollation' setting.
IgnoreComments bool?
A true or false value for the 'IgnoreComments' setting.
IgnoreCryptographicProviderFilePath bool?
A true or false value for the 'IgnoreCryptographicProviderFilePath' setting.
IgnoreDdlTriggerOrder bool?
A true or false value for the 'IgnoreDdlTriggerOrder' setting.
IgnoreDdlTriggerState bool?
A true or false value for the 'IgnoreDdlTriggerState' setting.
IgnoreDefaultSchema bool?
A true or false value for the 'IgnoreDefaultSchema' setting.
IgnoreDmlTriggerOrder bool?
A true or false value for the 'IgnoreDmlTriggerOrder' setting.
IgnoreDmlTriggerState bool?
A true or false value for the 'IgnoreDmlTriggerState' setting.
IgnoreExtendedProperties bool?
A true or false value for the 'IgnoreExtendedProperties' setting.
IgnoreFileAndLogFilePath bool?
A true or false value for the 'IgnoreFileAndLogFilePath' setting.
IgnoreFilegroupPlacement bool?
A true or false value for the 'IgnoreFilegroupPlacement' setting.
IgnoreFileSize bool?
A true or false value for the 'IgnoreFileSize' setting.
IgnoreFillFactor bool?
A true or false value for the 'IgnoreFillFactor' setting.
IgnoreFullTextCatalogFilePath bool?
A true or false value for the 'IgnoreFullTextCatalogFilePath' setting.
IgnoreIdentitySeed bool?
A true or false value for the 'IgnoreIdentitySeed' setting.
IgnoreIncrement bool?
A true or false value for the 'IgnoreIncrement' setting.
IgnoreIndexOptions bool?
A true or false value for the 'IgnoreIndexOptions' setting.
IgnoreIndexPadding bool?
A true or false value for the 'IgnoreIndexPadding' setting.
IgnoreKeywordCasing bool?
A true or false value for the 'IgnoreKeywordCasing' setting.
IgnoreLockHintsOnIndexes bool?
A true or false value for the 'IgnoreLockHintsOnIndexes' setting.
IgnoreLoginSids bool?
A true or false value for the 'IgnoreLoginSids' setting.
IgnoreNotForReplication bool?
A true or false value for the 'IgnoreNotForReplication' setting.
IgnoreObjectPlacementOnPartitionScheme bool?
A true or false value for the 'IgnoreObjectPlacementOnPartitionScheme' setting.
IgnorePartitionSchemes bool?
A true or false value for the 'IgnorePartitionSchemes' setting.
IgnorePermissions bool?
A true or false value for the 'IgnorePermissions' setting.
IgnoreQuotedIdentifiers bool?
A true or false value for the 'IgnoreQuotedIdentifiers' setting.
IgnoreRoleMembership bool?
A true or false value for the 'IgnoreRoleMembership' setting.
IgnoreRouteLifetime bool?
A true or false value for the 'IgnoreRouteLifetime' setting.
IgnoreSemicolonBetweenStatements bool?
A true or false value for the 'IgnoreSemicolonBetweenStatements' setting.
IgnoreTableOptions bool?
A true or false value for the 'IgnoreTableOptions' setting.
IgnoreUserSettingsObjects bool?
A true or false value for the 'IgnoreUserSettingsObjects' setting.
IgnoreWhitespace bool?
A true or false value for the 'IgnoreWhitespace' setting.
IgnoreWithNocheckOnCheckConstraints bool?
A true or false value for the 'IgnoreWithNocheckOnCheckConstraints' setting.
IgnoreWithNocheckOnForeignKeys bool?
A true or false value for the 'IgnoreWithNocheckOnForeignKeys' setting.
IncludeAcls bool?
If true, include ACLs in the operation (applies to the file system, registry, and metabase).
Inherited from MsDeployProvider
IncludeCompositeObjects bool?
A true or false value for the 'IncludeCompositeObjects' setting.
IncludeData bool?
A true or false value for the 'includeData' setting.
IncludeTransactionalScripts bool?
A true or false value for the 'IncludeTransactionalScripts' setting.
NoAlterStatementsToChangeClrTypes bool?
A true or false value for the 'NoAlterStatementsToChangeClrTypes' setting.
Password string
Password of the user for remote connections (required if using Basic authentication).
Inherited from MsDeployProvider
Path string
Path of the provider type
Inherited from MsDeployProvider
PopulateFilesOnFileGroups bool?
A true or false value for the 'PopulateFilesOnFileGroups' setting.
PublishSettings string
Inherited from MsDeployProvider
RegisterDataTierApplication bool?
A true or false value for the 'RegisterDataTierApplication' setting.
RequirePath bool
Determines if the Path argument is required for the MsDeployProvider
Inherited from MsDeployProvider
RunDeploymentPlanExecutors bool?
A true or false value for the 'RunDeploymentPlanExecutors' setting.
ScriptDatabaseCollation bool?
A true or false value for the 'ScriptDatabaseCollation' setting.
ScriptDatabaseCompatibility bool?
A true or false value for the 'ScriptDatabaseCompatibility' setting.
ScriptDatabaseOptions bool?
A true or false value for the 'ScriptDatabaseOptions' setting.
ScriptDeployStateChecks bool?
A true or false value for the 'ScriptDeployStateChecks' setting.
ScriptFileSize bool?
A true or false value for the 'ScriptFileSize' setting.
ScriptNewConstraintValidation bool?
A true or false value for the 'ScriptNewConstraintValidation' setting.
ScriptRefreshModule bool?
A true or false value for the 'ScriptRefreshModule' setting.
TempAgent bool?
Inherited from MsDeployProvider
TreatVerificationErrorsAsWarnings bool?
A true or false value for the 'TreatVerificationErrorsAsWarnings' setting.
Type string
UnmodifiableObjectWarnings bool?
A true or false value for the 'UnmodifiableObjectWarnings' setting.
Username string
User name to authenticate for remote connections (required if using Basic authentication).
Inherited from MsDeployProvider
VerifyCollationCompatibility bool?
A true or false value for the 'VerifyCollationCompatibility' setting.
VerifyDeployment bool?
A true or false value for the 'VerifyDeployment' setting.
WebManagementService string
Name of remote computer or proxy-URL for the Web Management Service (WMSvc). Assumes that the service is listening on port 8172.
Inherited from MsDeployProvider

Methods

Name Value Summary
AdditionalSettings(StringBuilder) void
AppendCommandLineArgument(StringBuilder) void
Converts the object into its MSDeploy command line equivalent and Appends it to the stringbuilder
Inherited from MsDeployProvider
ToCommandLineArgument() string
Converts the MSDeploy Provider into its commmand line argument
Inherited from MsDeployProvider