MSBuild.ExtensionPack.SqlServer NamespaceMSBuild Extension Pack Help 4.0.8.0

Overview

This namespace currently hosts the various SqlServer tasks
Classes

  ClassDescription
Public classBuildDeploymentManifest
This Task can be used to translate SSIS projects (.dtproj files) into an SSIS deployment manifest

Remote Execution Support: NA

Public classBuildNumber
Public classSqlCmd
Wraps the SQL Server command line executable SqlCmd.exe.

Valid TaskActions are:

Execute (Required: CommandLineQuery or InputFiles Optional: Database, DedicatedAdminConnection, DisableVariableSubstitution, EchoInput, EnableQuotedIdentifiers, Headers, LoginTimeout, LogOn, NewPassword, OutputFile, Password, QueryTimeout, RedirectStandardError, Server, SeverityLevel, SqlCmdPath, UnicodeOutput, UseClientRegionalSettings, Variables, Workstation)

Remote Execution Support: Yes

Public classSqlExecute
Valid TaskActions are:

Execute (Required: ConnectionString, Sql or Files Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors, StripMultiLineComments Output: FailedScripts)

ExecuteRawReader (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: RawReaderResult, FailedScripts)

ExecuteReader (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: ReaderResult, FailedScripts)

ExecuteScalar (Required: ConnectionString, Sql Optional: CodePage, CommandTimeout, Parameters, Retry, UseTransaction, IgnoreScriptErrors Output: ScalarResult, FailedScripts)

Remote Execution Support: NA

Public classSqlVersion
The SqlVersion task provides the ability to manage multiple build versions in a simple database table.

Valid TaskActions are:

GetVersion (Required: BuildName, DatabaseName Optional: Delimiter, FieldToIncrement, PaddingCount, PaddingDigit Output: Build, Major, Minor, Revision, Version)

Remote Execution Support: Yes

Public classSqlVersionDataClass