The Build task
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.
Want to Find out More?
Overview
Request a demo
