Invoke-DevartDatabaseBuild

Synopsis

Builds a database on a server.

Description

The cmdlet builds a database project by checking if the database definition can be deployed to an empty database. In case the build is successful, an object that represents the built project is created.

Syntax

Invoke-DevartDatabaseBuild -Connection <object> -SourceScriptsFolder <string> [-FilterPath <string>] [-QueryBatchTimeout <int>] [-SynchronizationOptions <string>] [-TransactionIsolationLevel <string>] [<CommonParameters>]

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 Schema 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 Schema 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 following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, InformationAction, InformationVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.

Outputs

Devart.DbForge.DevOpsAutomation.SqlServer.DatabaseProject

Examples

---------- EXAMPLE 1 ----------
$databaseProject = Invoke-DevartDatabaseBuild -SourceScriptsFolder $scriptFolder -Connection $connection

See Options used in the command line for a complete list of supported SynchronizationOptions.

See Using Object Filter to learn how to generate a Schema Compare filter options file.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge DevOps Automation for SQL Server.
Request a demo

Request a demo

If you consider employing the DevOps Automation for your business, request a demo to see it in action.
Ready to start using dbForge DevOps Automation for SQL Server?
Download a free 30-day trial