< Back
Invoke-DevartDatabaseBuild
Post
NAME Invoke-DevartDatabaseBuild
SYNOPSIS
Builds a database on a server.
SYNTAX
Invoke-DevartDatabaseBuild -Connection <object> -SourceScriptsFolder <string> [-FilterPath <string>]
[-QueryBatchTimeout <int>] [-SynchronizationOptions <string>] [-TransactionIsolationLevel <string>]
[<CommonParameters>]
DESCRIPTION
PARAMETERS
-Connection <object>
Connection to the server where a database will be built.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceScriptsFolder <string>
Path to the folder with scripts from which a database will be built.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-FilterPath <string>
Specifies the SQL Compare filter options used when validating the schema.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SynchronizationOptions <string>
Specifies the SQL Compare options used during creation of the script for validation.
To include additional options, specify a slash-separated list of the options.
For example: /IgnoreCase:Yes /IgnorePrimaryKeys:No
See related links for more detailed information about options.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TransactionIsolationLevel <string>
Use this parameter to specify the isolation level for the transactions during the temporary deployment for
validation.
Permitted values are: Serializable, Snapshot, RepeatableRead, ReadCommitted and ReadUncommitted. The default
level is Serializable.
Required? false
Position? named
Default value Serializable
Accept pipeline input? false
Accept wildcard characters? false
-QueryBatchTimeout <int>
Parameter is applied for each of the following expressions in a database creation script if the Connection
parameter is an object of the DevartDatabaseConnectionInfo type.
Required? false
Position? named
Default value 30
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Devart.DbForge.DevOpsAutomation.SqlServer.DatabaseProject
---------- EXAMPLE 1 ----------
$databaseProject = Invoke-DevartDatabaseBuild -SourceScriptsFolder $scriptFolder -Connection $connection
RELATED LINKS
See web documentation for a complete list of supported SynchronizationOptions.
http://docs.devart.com/schema-compare-f ... -line.html
Online help: https://docs.devart.com/devops-automati ... build.html
SYNOPSIS
Builds a database on a server.
SYNTAX
Invoke-DevartDatabaseBuild -Connection <object> -SourceScriptsFolder <string> [-FilterPath <string>]
[-QueryBatchTimeout <int>] [-SynchronizationOptions <string>] [-TransactionIsolationLevel <string>]
[<CommonParameters>]
DESCRIPTION
PARAMETERS
-Connection <object>
Connection to the server where a database will be built.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SourceScriptsFolder <string>
Path to the folder with scripts from which a database will be built.
Required? true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-FilterPath <string>
Specifies the SQL Compare filter options used when validating the schema.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-SynchronizationOptions <string>
Specifies the SQL Compare options used during creation of the script for validation.
To include additional options, specify a slash-separated list of the options.
For example: /IgnoreCase:Yes /IgnorePrimaryKeys:No
See related links for more detailed information about options.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TransactionIsolationLevel <string>
Use this parameter to specify the isolation level for the transactions during the temporary deployment for
validation.
Permitted values are: Serializable, Snapshot, RepeatableRead, ReadCommitted and ReadUncommitted. The default
level is Serializable.
Required? false
Position? named
Default value Serializable
Accept pipeline input? false
Accept wildcard characters? false
-QueryBatchTimeout <int>
Parameter is applied for each of the following expressions in a database creation script if the Connection
parameter is an object of the DevartDatabaseConnectionInfo type.
Required? false
Position? named
Default value 30
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
Devart.DbForge.DevOpsAutomation.SqlServer.DatabaseProject
---------- EXAMPLE 1 ----------
$databaseProject = Invoke-DevartDatabaseBuild -SourceScriptsFolder $scriptFolder -Connection $connection
RELATED LINKS
See web documentation for a complete list of supported SynchronizationOptions.
http://docs.devart.com/schema-compare-f ... -line.html
Online help: https://docs.devart.com/devops-automati ... build.html