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

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["DbFullSqlProvider"] class Type type-node

Syntax

public class DbFullSqlProvider : MsDeployProvider, IMsDeployProvider, IMsDeployArgument

Constructors

Name	Summary
DbFullSqlProvider()

Properties

Name	Value	Summary
AppendQuotesToPath	bool	Determines if the Path is surrounded in "quotes" Inherited from MsDeployProvider
AuthenticationType	Nullable<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
CommandDelimiter	string	A string that is used to separate database commands in the script.
CommandTimeout	Nullable<int>	An integer value for the 'commandTimeout' setting.
ComputerName	string	Name of remote computer or proxy-URL Inherited from MsDeployProvider
CreateDBConnectionString	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
DropDestinationDatabase	Nullable<bool>	A true or false value for the 'dropDestinationDatabase' setting.
ForceScriptDatabase	Nullable<bool>	A true or false value for the 'forceScriptDatabase' setting.
IncludeAcls	Nullable<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
RemoveCommandDelimiter	Nullable<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	Nullable<bool>	A true or false value for the 'scriptDropsFirst' setting.
SkipSqlCmdParsing	Nullable<bool>	A true or false value for the 'skipSqlCmdParsing' setting.
SqlCe	Nullable<bool>	A true or false value for the 'sqlCe' setting.
StoreConnectionStringPassword	Nullable<bool>	A true or false value for the 'storeConnectionStringPassword' setting.
TempAgent	Nullable<bool>	Inherited from MsDeployProvider
Transacted	Nullable<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(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

Extension Methods