GUI for implementing automated unit testing based on the open-source tSQLt framework in SQL Server Management Studio
Version: 1.5.82GUI for implementing automated unit testing in SQL Server Management Studio.
License: Free To Try $199.95
Operating System: Windows
The 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 for SQL Server functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level.
By downloading dbForge SQL Tools (dbForge Unit Test included), you get 14 full-featured tools that greatly extend standard SSMS functionality and bring your productivity to the next level.
Key Features: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.
Run Multiple Tests in Less Time. dbForge Unit Test for SQL Server allows to quickly run multiple tests with just a few clicks and get instant results.
You can simultaneously run all unit tests at once or select any combination of tests for a unit test session.
Version 1.5.82: Several user reported bugs are fixed
Version 1.4: Connectivity support for SQL Server 2019 Product now integrates into SSMS v18 Lots of Azure improvements implemented
Version 1.3: *SQL Server 2016 Service Pack 1 (SP1) new syntax support *SQL Server 2017 new syntax support *The latest SQL Server Management Studio v17.2 integration support *Azure SQL Data Warehouse support