| Database Properties | MSBuild Extension Pack Help 4.0.12.0 |
The Database type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
BackupAction |
Sets the type of backup action to perform. Supports Database, Files and Log. Default is Database
|
|
|
Collation |
Sets the collation of the database.
|
|
|
CompressionOption |
Sets the compression option for the backup. Supports On, Off and Default. Default is Default.
|
|
|
ConnectionCount |
Gets the number of connections the database has open
|
|
|
CopyOnly |
Sets whether the backup is a copy-only backup. Default is false.
|
|
|
DatabaseItem |
Sets the database name. When using Attach, you can specify the following metadata: Owner, Files (semicolon delimited), AttachOptions (Default None). When using Detach, you can specify the following metadata: UpdateStatistics, RemoveFulltextIndexFile (both default to false).
|
|
|
DataFilePath |
Sets the DataFilePath.
|
|
|
Exists |
Gets whether the database exists
|
|
|
FileGroupName |
Sets the FileGroupName. Defaults to PRIMARY
|
|
|
Force |
Set to true to force the creation of a database if it already exists.
|
|
|
Incremental |
Set to true to perform an Incremental backup. Default is false.
|
|
|
Information |
Gets the Information TaskItem. Each available property is added as metadata.
|
|
|
LogFilePath |
Sets the LogFilePath.
|
|
|
LogName |
Sets the Log Name. Defaults DatabaseItem.ItemSpec + "_log"
|
|
|
NewDataFilePath |
Sets the NewDataFilePath.
|
|
|
NoPooling |
Set to true to create a NonPooledConnection to the server. Default is false.
|
|
|
NotificationInterval |
Sets the PercentCompleteNotification interval. Defaults to 10.
|
|
|
OutputFilePath |
Sets the OutputFilePath.
|
|
|
PrimaryDataFileName |
Sets the primary data file name.
|
|
|
RegexPattern |
Sets the regex pattern.
|
|
|
ReplaceDatabase |
A Boolean value that specifies whether a new image of the restored database will be created. If True, a new image of the database is created. The image is created regardless of the presence of an existing database with the same name. If False (default), a new image of the database is not created by the restore operation. The database targeted by the restore operation must exist on an instance of Microsoft SQL Server.
|
|
|
RestoreAction |
Sets the type of restore action to perform. Supports Database, Files, Log, OnlineFiles, OnlinePage. Default is Database
|
|
|
ScriptDrops |
Sets ScriptingOptions for ScriptData TaskAction
|
|
|
ScriptSchema |
Sets ScriptingOptions for ScriptData TaskAction
|
|
|
SecondaryDataFileName |
Sets the secondary data file name. No default value.
|
|
|
SecondaryDataFilePath |
Sets the SecondaryDataFilePath.
|
|
|
StatementTimeout |
Sets the number of seconds before an operation times out. The default is not to specify this property on the connection.
|
See Also