The Execute task

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.

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?