MSBuild.ExtensionPack.Sql2008 NamespaceMSBuild 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

  ClassDescription
Public classCode exampleAnalysisServices
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 classCode exampleDatabase
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 classCode exampleServer
Valid TaskActions are:

GetConnectionCount (Optional: NoPooling Output: ConnectionCount)

GetInfo (Optional: NoPooling Output: Information)

Remote Execution Support: Yes