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
Optional: Provide the description for the 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
Enter the name of the target server, e.g., SERVERNAME\INSTANCENAME.
Enter the name of the target database.
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
Specify the encoding to be used to open and execute the script.
Enter a password to the protected archive file.
Select to display the password.
Select to allow the execution of scripts to continue even if errors occur.