Summary
Deploy SQL database
- Namespace
- Cake
.MsDeploy .Providers .MsDeployProviders - Interfaces
- Base Types
-
- object
- MsDeployProvider
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["DbFullSqlProvider"]
class Type type-node
Syntax
public class DbFullSqlProvider : MsDeployProvider, IMsDeployProvider, IMsDeployArgumentProperties
| Name | Value | Summary |
|---|---|---|
| AppendQuotesToPath | bool |
Determines if the Path is surrounded in "quotes"
Inherited from MsDeployProvider
|
| AuthenticationType | Authentication |
Authentication scheme to use. NTLM is the default setting. If the wmsvc option is specified, then Basic is the default setting.
Inherited from MsDeployProvider
|
| CommandDelimiter | string |
A string that is used to separate database commands in the script.
|
| CommandTimeout | int? |
An integer value for the 'commandTimeout' setting.
|
| ComputerName | string |
Name of remote computer or proxy-URL
Inherited from MsDeployProvider
|
| Create |
string |
A connection string used to create the database on the destination if the database specified in the
|
| Direction | Direction |
Determines if the Provider is a source or destination
Inherited from MsDeployProvider
|
| Drop |
bool? |
A true or false value for the 'dropDestinationDatabase' setting.
|
| ForceScriptDatabase | bool? |
A true or false value for the 'forceScriptDatabase' setting.
|
| IncludeAcls | bool? |
If true, include ACLs in the operation (applies to the file system, registry, and metabase).
Inherited from MsDeployProvider
|
| ObjectList | string |
A semi-colon delimited list of SQL objects that you want to script from the database.
|
| 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
|
| PublishSettings | string |
Inherited from MsDeployProvider
|
| Remove |
bool? |
A true or false value for the 'removeCommandDelimiter' setting.
|
| RequirePath | bool |
Determines if the Path argument is required for the MsDeployProvider
Inherited from MsDeployProvider
|
| ScriptDropsFirst | bool? |
A true or false value for the 'scriptDropsFirst' setting.
|
| SkipSqlCmdParsing | bool? |
A true or false value for the 'skipSqlCmdParsing' setting.
|
| SqlCe | bool? |
A true or false value for the 'sqlCe' setting.
|
| Store |
bool? |
A true or false value for the 'storeConnectionStringPassword' setting.
|
| TempAgent | bool? |
Inherited from MsDeployProvider
|
| Transacted | bool? |
A true or false value for the 'transacted' setting.
|
| Type | string | |
| Username | string |
User name to authenticate for remote connections (required if using Basic authentication).
Inherited from MsDeployProvider
|
| 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
|