MSBuild.ExtensionPack.Sql2012 Namespace

MSBuild Extension Pack

MSBuild.ExtensionPack.Sql2012 Namespace MSBuild Extension Pack Help 4.0.12.0
Classes

  Class Description
Public class Code example AnalysisServices
Valid TaskActions are:

ScriptAlter (Required: DatabaseItem, OutputFile)

ScriptCreate (Required: DatabaseItem, OutputFile)

ScriptDelete (Required: DatabaseItem, OutputFile)

Execute (Required: InputFile)

Process (Required: DatabaseItem Optional: ProcessType)

Remote Execution Support: Yes

Public class Code example Database
Valid TaskActions are:

Attach (Required: DatabaseItem Optional: See notes on metadata for DatabaseItem)

Backup (Required: DatabaseItem, DataFilePath Optional: BackupAction, CompressionOption, Incremental, NotificationInterval, NoPooling, StatementTimeout, CopyOnly)

CheckExists (Required: DatabaseItem Optional: NoPooling, StatementTimeout Output: Exists)

Create (Required: DatabaseItem Optional: Collation, NoPooling, DataFilePath, LogName, LogFilePath, FileGroupName, StatementTimeout)

Delete (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

DeleteBackupHistory (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

Detach (Required: DatabaseItem Optional: See notes on metadata for DatabaseItem)

GetConnectionCount (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

GetInfo (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

Rename (Required: DatabaseItem (NewName metadata) Optional: NoPooling, StatementTimeout)

Restore (Required: DatabaseItem, DataFilePath Optional: ReplaceDatabase, NewDataFilePath, RestoreAction, Incremental, NotificationInterval, NoPooling, LogName, LogFilePath, PrimaryDataFileName, SecondaryDataFileName, SecondaryDataFilePath, StatementTimeout)

Script (Required: DatabaseItem, OutputFilePath Optional: NoPooling, StatementTimeout)

ScriptData (Required: DatabaseItem, OutputFilePath Optional: ScriptDrops, ScriptSchema, NoPooling, StatementTimeout)

SetOffline (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

SetOnline (Required: DatabaseItem Optional: NoPooling, StatementTimeout)

VerifyBackup (Required: DataFilePath Optional: NoPooling, StatementTimeout)

Remote Execution Support: Yes

Public class Code example Server
Valid TaskActions are:

GetConnectionCount (Optional: NoPooling Output: ConnectionCount)

GetInfo (Optional: NoPooling Output: Information)

Remote Execution Support: Yes