The Test step

Last modified: November 18, 2024

Synopsis

Runs unit tests on a deployed database.

Description

The Test task in the CI/CD pipeline is a crucial phase that ensures the quality and stability of your database by running unit tests on a deployed database. This task validates that the recent changes to the database schema, configurations, and data migration scripts have not introduced any issues or unexpected behavior.

How to create the Test task

To add this step, go to the Build Steps section in the settings of your project and click the Add build step button. Then in the drop-down list that appears, select dbForge DevOps Automation for SQL Server – Test. After that, the user interface for the Test step will be displayed.

Customization options

Runner type

Build runner is a part of TeamCity that allows integration with a specific build tool. Select dbForge DevOps Automation for SQL Server - Build here.

Step name

Optional: Specify the step name to distinguish it from other steps.

Execute step

Specify the step execution policy. Here you can select from the following options:

If all previous steps finished successfully
Only if build status is successful
Even if some of the previous steps failed
Always, even if build stop command was issued
Package ID

Enter the ID of the package that you want to test. The ID must be for a package built by dbForge DevOps Automation for SQL Server.

Temporary database server

Specify the temporary server for dbForge DevOps Automation for SQL Server to recreate and validate your database on. You have the following options here: