For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL unit testing

ApexSQL Unit Test is a SQL Server Management Studio add-in used to manage SQL database unit tests. Besides the set of pre-defined tests and a Demo kit that includes a sample database and a set of sample unit tests, ApexSQL Unit Test can be used to create, maintain and run unit tests against any database, and even run tests on multiple databases on the same SQL Server as well as on multiple SQL Server instances at the same time.
An introduction to ApexSQL Unit Test 07:41

Benefits

  • 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

Assistant Chief Engineer

I've tried the ApexSQL Doc and ApexSQL Unit Test. My comment is: "Excellent Tools, great Technical Support. Thanks ApexSQL

Jasper Lai Assistant Chief Engineer

Siopti.d.o.o

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

ApexSQL Unit Test is part of the ApexSQL DevOps toolkit

ApexSQL Unit Test is part of the ApexSQL DevOps toolkit