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.

  • 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

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.
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.
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.
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.
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.
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.
Tools
View all features

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.

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

dbForge SQL Tools

Enhance SSMS with essential add-ins and tools, including Unit Test, and boost all database-related tasks
SAVE UP
TO $2309

Get more solutions