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> [-QueryBatchTimeout <int>] [-SynchronizationOptions <string>] [-TransactionIsolationLevel <string>] [<CommonParameters>]

Parameters

 -Connection <object>

Connection to the server where a database will be build.

Required? true

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-SourceScriptsFolder <string>

Path to the folder with scripts from which a database will be build.

Required? true

Position? named

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

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

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

-FilterPath <string>

Specifies the Schema Compare filter options used when validating the schema.

Required? false

Position? named

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 web documentation for a complete list of supported synchronization options.