The Execute step

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

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?