Create and run SQL Server unit tests

Last modified: May 28, 2025

This section covers the process of setting up and managing unit tests for SQL Server databases. It includes installing and uninstalling a test framework, using a sample database, creating new tests, and viewing the test list. Instructions are provided for running all tests, identifying failures, and resolving issues to ensure database logic behaves as expected. This functionality helps maintain code quality and prevent regressions during development.

In this section

Install a test framework

Uninstall a test framework

Install a sample database

Add a new test

View a test list

Run all tests

Fix failed tests

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

dbForge Studio for SQL Server logo

Ready to start using  

dbForge Studio for SQL Server?

Download a FREE 30-day trial