| 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)| Class | Description | |
|---|---|---|
|
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 |
|
|
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 |
|
|
Server |
Valid TaskActions are:
GetConnectionCount (Optional: NoPooling Output: ConnectionCount) GetInfo (Optional: NoPooling Output: Information) Remote Execution Support: Yes |