DbForge Unit Test for SQL Server

dbForge Unit Test for SQL Server is an SQL Server Management Studio plug-in, which allows you to write unit tests against SQL Server databases, using tSQLt framework. After installing it in SSMS, it can be accessed by right clicking on one of the databases.

When installing the plug-in, you will have the option to install it in different versions of SQL Server Management Studio. You will be also able to generate native images, to speed up the startup.

In order to create new tests, tSQLt framework must be installed on the selected database. This allows you to write tests in regular T-SQL and use SQL tables, views, procedures and functions that come included within the framework. It also allows you to write code in the same integrated development environment as execution of unit testing.

No database changes will be made during the tests, as this plug-in automatically reverses them. Tests are also done on a separate test objects within isolated unit, thus no unnecessary database modifications are made. Also, any number of chosen unit tests can be run at the same time.

For the reference, dbForge Unit Test for SQL Server comes with some examples, for you to get to know all the options available with the plug-in, before starting to implement your own unit tests. Also, support for the latest SQL Server and SQL Server Management Studio is included.