The Test step

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:

  • SQL LocalDB (recommended)

  • SQL Server

  • Run tests

Specify how tests are to be run. Here you can select from:

  • Run every test

  • Run selected tests only

  • Generate test data

Select to populate the database with data before testing.

Advanced options

  • Schema Compare options

Specify additional Schema Compare options.

  • Schema Compare filter

Specify a path to an alternative filter file which will be used for validating the schema to override *.scflt filter file present in the input.

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?
Download a free 30-day trial