The Build task

Last modified: November 18, 2024

Synopsis

Builds a database on a server.

Description

The Build task involves building a database package and deploying it on a specific server. This package is typically created from a script folder containing SQL or other database-related files.

How to create the Build task

To add the Build task, in the Configure Job view, click Add task in the Create task section.

Locate and select dbForge DevOps Automation – Build among the provided components from the installed plug-ins.

Customization options

• Task description

Optional: Provide the description for the task.

• Disable this task

Select to disable the task in your pipeline. If a task is disabled, it will be skipped during the pipeline execution.

• Database project

Select whether the database source project is located in the repository’s root directory or within a subfolder path. In case your database project is located in the subfolder, enter a path to it, for instance, if your script-folder is located in D:\Repository\Scripts, enter \Scripts.

• Package ID:

Specify the ID of the package that you want to build. Normally the package version defaults to the build number. If you need to override this, please specify a package version in the Override package version field below.

• Temporary database server

Specify the temporary server for dbForge DevOps Automation for SQL Server to recreate and validate your database on. You have the following options here:

• SQL LocalDB (recommended)
• SQL Server

Advanced options

• Schema Compare options

Specify additional Schema Compare options.

• Schema Compare filter

Specify a path to an alternative filter file which will be used for validating the schema to override *.scflt filter file present in the input.

• Transaction isolation level

Select the transaction isolation level. By default, the selected level is Serializable.

• Query Batch Timeout

Specify the timeout, in seconds, for query batches. If the timeout is set to 0, it means there is no timeout. The default value for most operations is 30 seconds.