The Execute task

Last modified: November 18, 2024

Synopsis

Runs specified SQL scripts in the pipeline.

Description

The Execute task allows for the flexible execution of SQL scripts, which can be used for a variety of purposes, such as to create a new database from custom scripts, execute migration scripts to update an existing database, or add unit tests for an already deployed database.

How to create the Execute task

To add the Execute task, in the Configure Job view, click Add task in the Create tasks section. Then locate and select dbForge DevOps Automation – Execute.

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.

Target database to execute

• Server

Enter the name of the target server, e.g., SERVERNAME\INSTANCENAME.

• Database

Enter the name of the target database.

• Authentication method

Select the authentication method to use: Windows authentication or SQL Server authentication.

Files to execute

Specifiy a path to a SQL or ZIP file with the script to execute or a folder with SQL or ZIP files. If a path refers to a folder, the scripts are executed in alphabetical order (subfolders are ignored).

Advanced options

• Encoding

Specify the encoding to be used to open and execute the script.

• Zip Password

Enter a password to the protected archive file.

• Show Password

Select to display the password.

• Ignore Error

Select to allow the execution of scripts to continue even if errors occur.