This content is part of a third party extension that is not supported by the Cake project.
For more information about this extension see Cake.MsDeploy.
Summary
Deploy SQL database using DACFx API
- Assembly
- Cake
.MsDeploy .dll - Namespace
- Cake
.MsDeploy .Providers .MsDeployProviders - Interfaces
- Base Types
-
- Object
- MsDeployProvider
graph BT
Type-->Base0["MsDeployProvider"]
click Base0 "/api/Cake.MsDeploy.Providers/MsDeployProvider"
Base0-->Base1["Object"]
Type-.->Interface0["IMsDeployProvider"]
click Interface0 "/api/Cake.MsDeploy.Providers/IMsDeployProvider"
Type-.->Interface1["IMsDeployArgument"]
click Interface1 "/api/Cake.MsDeploy/IMsDeployArgument"
Type["DbDacFxProvider"]
class Type type-node
Syntax
public class DbDacFxProvider : MsDeployProvider, IMsDeployProvider, IMsDeployArgument
Constructors
Name | Summary |
---|---|
DbDacFxProvider |
Properties
Name | Value | Summary |
---|---|---|
Allow |
Nullable |
A true or false value for the 'AllowDropBlockingAssemblies' setting.
|
Allow |
Nullable |
A true or false value for the 'AllowIncompatiblePlatform' setting.
|
AppendQuotesToPath | bool |
Determines if the Path is surrounded in "quotes"
Inherited from MsDeployProvider
|
AuthenticationType | Nullable |
Authentication scheme to use. NTLM is the default setting. If the wmsvc option is specified, then Basic is the default setting.
Inherited from MsDeployProvider
|
Backup |
Nullable |
A true or false value for the 'BackupDatabaseBeforeChanges' setting.
|
Block |
Nullable |
A true or false value for the 'BlockOnPossibleDataLoss' setting.
|
Block |
Nullable |
A true or false value for the 'BlockWhenDriftDetected' setting.
|
CommandTimeout | Nullable |
An integer value for the 'commandTimeout' setting.
|
Comment |
Nullable |
A true or false value for the 'CommentOutSetVarDeclarations' setting.
|
Compare |
Nullable |
A true or false value for the 'CompareUsingTargetCollation' setting.
|
ComputerName | string |
Name of remote computer or proxy-URL
Inherited from MsDeployProvider
|
CreateNewDatabase | Nullable |
A true or false value for the 'CreateNewDatabase' setting.
|
DacpacAction | DacpacAction |
A value that is one of 'Deploy, Script, Report'.
|
Deploy |
Nullable |
A true or false value for the 'DeployDatabaseInSingleUserMode' setting.
|
Direction | Direction |
Determines if the Provider is a source or destination
Inherited from MsDeployProvider
|
Disable |
Nullable |
A true or false value for the 'DisableAndReenableDdlTriggers' setting.
|
Do |
Nullable |
A true or false value for the 'DoNotAlterChangeDataCaptureObjects' setting.
|
Do |
Nullable |
A true or false value for the 'DoNotAlterReplicatedObjects' setting.
|
Drop |
Nullable |
A true or false value for the 'DropConstraintsNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'dropDestinationDatabase' setting.
|
Drop |
Nullable |
A true or false value for the 'DropDmlTriggersNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropExtendedPropertiesNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropIndexesNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropObjectsNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropPermissionsNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropRoleMembersNotInSource' setting.
|
Drop |
Nullable |
A true or false value for the 'DropStatisticsNotInSource' setting.
|
Generate |
Nullable |
A true or false value for the 'GenerateSmartDefaults' setting.
|
IgnoreAnsiNulls | Nullable |
A true or false value for the 'IgnoreAnsiNulls' setting.
|
IgnoreAuthorizer | Nullable |
A true or false value for the 'IgnoreAuthorizer' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreColumnCollation' setting.
|
IgnoreComments | Nullable |
A true or false value for the 'IgnoreComments' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreCryptographicProviderFilePath' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreDdlTriggerOrder' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreDdlTriggerState' setting.
|
IgnoreDefaultSchema | Nullable |
A true or false value for the 'IgnoreDefaultSchema' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreDmlTriggerOrder' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreDmlTriggerState' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreExtendedProperties' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreFileAndLogFilePath' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreFilegroupPlacement' setting.
|
IgnoreFileSize | Nullable |
A true or false value for the 'IgnoreFileSize' setting.
|
IgnoreFillFactor | Nullable |
A true or false value for the 'IgnoreFillFactor' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreFullTextCatalogFilePath' setting.
|
IgnoreIdentitySeed | Nullable |
A true or false value for the 'IgnoreIdentitySeed' setting.
|
IgnoreIncrement | Nullable |
A true or false value for the 'IgnoreIncrement' setting.
|
IgnoreIndexOptions | Nullable |
A true or false value for the 'IgnoreIndexOptions' setting.
|
IgnoreIndexPadding | Nullable |
A true or false value for the 'IgnoreIndexPadding' setting.
|
IgnoreKeywordCasing | Nullable |
A true or false value for the 'IgnoreKeywordCasing' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreLockHintsOnIndexes' setting.
|
IgnoreLoginSids | Nullable |
A true or false value for the 'IgnoreLoginSids' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreNotForReplication' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreObjectPlacementOnPartitionScheme' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnorePartitionSchemes' setting.
|
IgnorePermissions | Nullable |
A true or false value for the 'IgnorePermissions' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreQuotedIdentifiers' setting.
|
IgnoreRoleMembership | Nullable |
A true or false value for the 'IgnoreRoleMembership' setting.
|
IgnoreRouteLifetime | Nullable |
A true or false value for the 'IgnoreRouteLifetime' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreSemicolonBetweenStatements' setting.
|
IgnoreTableOptions | Nullable |
A true or false value for the 'IgnoreTableOptions' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreUserSettingsObjects' setting.
|
IgnoreWhitespace | Nullable |
A true or false value for the 'IgnoreWhitespace' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreWithNocheckOnCheckConstraints' setting.
|
Ignore |
Nullable |
A true or false value for the 'IgnoreWithNocheckOnForeignKeys' setting.
|
IncludeAcls | Nullable |
If true, include ACLs in the operation (applies to the file system, registry, and metabase).
Inherited from MsDeployProvider
|
Include |
Nullable |
A true or false value for the 'IncludeCompositeObjects' setting.
|
IncludeData | Nullable |
A true or false value for the 'includeData' setting.
|
Include |
Nullable |
A true or false value for the 'IncludeTransactionalScripts' setting.
|
No |
Nullable |
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
|
Populate |
Nullable |
A true or false value for the 'PopulateFilesOnFileGroups' setting.
|
PublishSettings | string |
Inherited from MsDeployProvider
|
Register |
Nullable |
A true or false value for the 'RegisterDataTierApplication' setting.
|
RequirePath | bool |
Determines if the Path argument is required for the MsDeployProvider
Inherited from MsDeployProvider
|
Run |
Nullable |
A true or false value for the 'RunDeploymentPlanExecutors' setting.
|
Script |
Nullable |
A true or false value for the 'ScriptDatabaseCollation' setting.
|
Script |
Nullable |
A true or false value for the 'ScriptDatabaseCompatibility' setting.
|
Script |
Nullable |
A true or false value for the 'ScriptDatabaseOptions' setting.
|
Script |
Nullable |
A true or false value for the 'ScriptDeployStateChecks' setting.
|
ScriptFileSize | Nullable |
A true or false value for the 'ScriptFileSize' setting.
|
Script |
Nullable |
A true or false value for the 'ScriptNewConstraintValidation' setting.
|
ScriptRefreshModule | Nullable |
A true or false value for the 'ScriptRefreshModule' setting.
|
TempAgent | Nullable |
Inherited from MsDeployProvider
|
Treat |
Nullable |
A true or false value for the 'TreatVerificationErrorsAsWarnings' setting.
|
Type | string | |
Unmodifiable |
Nullable |
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
|
Verify |
Nullable |
A true or false value for the 'VerifyCollationCompatibility' setting.
|
VerifyDeployment | Nullable |
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 |
void | |
Append |
void |
Converts the object into its MSDeploy command line equivalent and Appends it to the stringbuilder
Inherited from MsDeployProvider
|
To |
string |
Converts the MSDeploy Provider into its commmand line argument
Inherited from MsDeployProvider
|
Extension Methods
Name | Value | Summary |
---|---|---|
Dump |
string |
Get a basic string representation of specified object.
From LoggingExtensions
Requires the Cake.Incubator addin
|
IsIn |
bool |
Checks if the source is contained in a list
From EnumerableExtensions
Requires the Cake.Incubator addin
|
NotNull |
void |
Throws an exception if the specified parameter's value is null.
From Extensions
Requires the Cake.Ftp addin
|
NotNull |
void |
From IssuesArgumentChecks
Requires the Cake.Issues addin
|
ThrowIfNull |
T |
Throws a
System.ArgumentNullException with a specific message if the value is null, otherwise returns the value
From AssertExtensions
Requires the Cake.Incubator addin
|
ThrowIfNull |
T |
Throws a
System.ArgumentNullException if the value is null, otherwise returns the value
From AssertExtensions
Requires the Cake.Incubator addin
|
ToDictionary |
IDictionary |
From ObjectHelpers
Requires the Cake.DeployParams addin
|
To |
string |
From StringExtensions
Requires the Cake.Issues addin
|