Write code in the same IDE as execution of unit testing No database changes are made during tests Run multiple tests at the same time Supports latest SQL Server and SSMS
Cons
None
DbForge Unit Test for SQL Server
Price: $
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.
Reviewed by Tony Hill (editor rating 4.5 out of 5 stars)