MSBuild.ExtensionPack.Sql2008 Namespace

MSBuild Extension Pack

MSBuild.ExtensionPack.Sql2008 Namespace MSBuild Extension Pack Help 4.0.12.0

Overview

This namespace currently hosts the Sql2008 tasks which provided various SMO functions.

Helpful Links

SQL Server Management Objects (SMO)
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