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