ApexSQL Unit Test

SQL database unit testing

Create, organize and run SQL database unit tests

?Integrate SQL unit testing directly into SSMS

?Install and manage tSQLt from multiple sources

?Create and organize test classes

?Automate test execution using the CLI

?Create and organize unit tests

?Write tests using T-SQL

?Run tests with a single click

?Manage all tests with a single form

Features

Test management from the Object Explorer pane

Create and run tests directly from the Object Explorer using the context menu

Single tab for test management

Manage all tests from a single form – the Unit Test explorer tab

Add a set of predefined SQL Cop tests to any database

Add SQL Cop tests to any database

Various ways to install the tSQLt framework

Multiple options are available for tSQLt installation including the built-in version, web, and file system

Full tSQLt management

Update to the most recent version of tSQLt with a single click or reinstall tSQLt. Uninstall tSQLt with an option to keep tests in a database, or to remove them along with tSQLt

Test class management

Create and organize test classes from the Unit Test explorer tab

Modify SQL database tests

Edit, delete or rename tests using the context menu in the Unit Test explorer tab

Run test directly from the Unit Test explorer tab

Run tests on a different node level, based on selection. This includes running a single test, all tests from the selected class, all tests against the selected database, and all tests on all databases on the selected SQL Server

CLI support

Automate test execution using the Command Line Interface, by specifying test classes and tests that will be executed

Testimonials

I've installed it and tried out a few things. And so far it's great :) It's not complicated and does not get in the way.

Goran Šiška

Software architect

Siopti.d.o.o

Roadmap

Export test execution results

Export unit test results directly from SSMS

Disabling tests

Disable specific test/group of tests

Editable test template

Edit template that is being used when a new test is created

Save a bundle

 

ApexSQL Unit Test is included in ApexSQL Developer

?14 ApexSQL developer tools

?Priority support

?1 year free support and upgrades

?New products added for free

?Combined 75% savings