Write SQL unit tests directly in SQL Server Management Studio

An intuitive and convenient GUI for implementing automated unit testing in SQL Server Management Studio. The dbForge SQL database unit testing tool is based on the open-source tSQLt framework, so SQL developers can now benefit from writing unit tests in regular T-SQL. The functionality of Unit Test allows you to develop stable and reliable code that can be properly regression-tested at the unit level.

Watch the Introductory Video

Launch object testing in isolation without adding extra data for IDs
Tests won't affect the actual database and won't need clean-up code
Run multiple SQL Server unit tests at once in a few clicks
Automate and simplify your SQL unit test process
Invoke unit tests via the command line interface
Get started with built-in unit testing examples
Write unit tests in regular T-SQL code

Feature Highlights

Using T-SQL for creating tests

The tool is based on the open-source tSQLt framework, a set of T-SQL tables, views, stored procedures, and functions.

SQL unit testing has never been easier. You don’t need to continuously switch between different tools to create the code and unit tests, with Unit Test for SQL Server you can do it within the same IDE.

Extensive tSQLt management

Install or uninstall tSQLt on any database with a single click. When uninstalling the framework, you can either save tests in the database or remove them along with tSQLt.

Installing the framework adds a number of stored procedures and functions, as well as an SQL CLR object to the database. You can use the framework to implement unit tests in T-SQL.

Uninstalling the framework removes the tSQLt stored procedures, functions, and CLR object from the database. You can select not to remove the tests you've created on the database.

Built-in Unit test examples

The tool comes with a number of pre-written unit test examples. This option will allow you to quickly start working with unit tests on the specified examples.

Add the predefined tests to any database and benefit from the best practices for test-driven database development.

Single-tab Test List Manager for test management

The tool provides a separate tab for managing, creating, removing, modifying, and running unit tests. You can also manage all tests that were run for execution in a separate results tab.

Unit Test for SQL Server saves your time and efforts so that you can concentrate on writing robust, error-free code.

Managing test classes

Test cases in tSQLt are grouped into test classes, so that you can gather similar SQL unit tests in the same test class.

With Unit Test for SQL Server you can conveniently create and organize test classes in the Test List Manager.

Create and customize tests for SQL databases

With the intuitive context menu of the Test List Manager, you can easily manipulate tests and classes:

create
edit
delete
rename

without having to constantly switch to another tool or IDE.

Why choose dbForge Unit Test

How to use SQL Unit Testing in development?

The dbForge Unit Test functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level. The tool is based on the open-source tSQLt framework.

Provides standardization and documentation

Unit testing has the greatest effect on the quality of your code. If you create the unit tests before you write the code you can use them as both design documentation and functional specifications.

Improve speed, quality, and testability

Add a collection of predefined unit test examples to any required database making it more effective right away. These examples are based on our best practices for test-driven database development.

Facilitates safe refactoring

It might be rather challenging to refactor massive databases and constantly keep an eye on all the tiniest changes. Unit tests can come in handy in this case and help you detect unnoticed faults before they cause any harm.

Reduces costs

Save money by purchasing a multi-purpose SSMS add-in instead of many specialized applications. Moreover, you can buy multiple licenses at a substantial discount.

Unit Test as part of DevOps Automation

Unit Test along with dbForge DevOps Automation for SQL Server makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Need a hand?

If you need any help or have questions about Devart tools or purchasing options, do not hesitate to get in touch with us.

Ordering FAQ

[email protected]

Get started with dbForge Unit Test at no cost

Download a FREE 30-day trial and start saving time spent on your routine database operations today.

Download free

Buy multiple licenses with a substantial discount

We provide flexible purchase options, including bulk discounts, to meet the budget of each and every customer.

Get it at: $169.95

Purchase now