Write tests in regular T-SQL
Last modified: September 5, 2023
dbForge Unit Test allows users to write tests in regular T-SQL, making it accessible and familiar to database professionals. This feature brings a number of key advantages:
Ease of use: Since T-SQL is a language commonly used by SQL developers, writing tests in this language reduces the learning curve and simplifies the process of creating unit tests. There’s no need to learn a new, specialized language for testing.
Use of tSQLt framework: The tool leverages the open-source tSQLt framework, which provides a set of T-SQL tables, views, stored procedures, and functions for the purposes of unit testing. This framework is well-established and widely used in the SQL Server community, bringing credibility and robustness to the testing process.
Running as many tests as you need: Execute multiple tests simultaneously with a single click. Simply select your desired tests, press one button, and the SQL Test UI will showcase each outcome as it is processed.
Simplification of complex testing: Because it uses simple queries for testing, it simplifies what can often be a complex process, making it easier for developers to ensure their SQL code is working as expected.
Video tutorial
Watch the video to learn how to perform automated unit testing in SSMS with dbForge Unit Test for SQL Server.