The Execute step

Last modified: November 18, 2024

Synopsis

Runs specified SQL scripts in the pipeline.

Description

The Execute step 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 step

Select dbForge DevOps Automation for SQL Server - Execute from Add build step drop-down menu:

And fill the following fields:

Customization options

• Target database to execute

Provide the server and database name, along with the authentication method. If you chose SQL Server Authentication, you will need to specify user name and password.

• Files to execute

Provide 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).