An intuitive and convenient GUI for implementing automated unit testing in SQL Server Management Studio. dbForge SQL 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. dbForge Unit Test functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level.

T-SQL for Implementing Tests

The tool is based on the open-source tSQLt framework allowing to use T-SQL for implementing unit tests. Now, you can write your code and executing unit tests in the same IDE. The framework also comes with SQL tables, views, procedures and functions to quickly implement unit tests against your database.

No Affect on Actual Database

dbForge Unit Test uses transactions to run test cases and rollback any changes to a database when the test case completes. This means you do not have to worry about the need of cleaning up your database after running unit tests.

In-isolation Testing

The tool creates stored procedure spies, fakes database objects (tables, views, triggers, constraints, etc.), and groups them within a separate schema unit. This allows to isolate the code being tested and avoid undesirable updates, inserts, and deletions inside a database.