You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
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

See next feature

Single tab for test management

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

See next feature

Add a set of predefined SQL Cop tests to any database

Add SQL Cop tests to any database

See next feature

Various ways to install the tSQLt framework

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

See next feature

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

See next feature

Test class management

Create and organize test classes from the Unit Test explorer tab

See next feature

Modify SQL database tests

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

See next feature

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

See next feature

CLI support

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

See next feature

How to create and run SQL Server database unit tests automatically

This article describes how to use ApexSQL Unit Test and how to automate test execution using PowerShell

ApexSQL Unit Test – Demo kit

This article describes how to implement the “Demo kit” feature which will automatically create a sample database install tSQLt framework and create a set of pre-defined tests

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

See our entire roadmap
ApexSQL Unit Test 2016 R2 Released ApexSQL Unit Test 2016 R3 Released ApexSQL Unit Test 2016 R5 Released ApexSQL Unit Test 2017 R1 Q4
General
Create demo kit with „PUBS QA“ sample database and 15 predefined unit tests
GUI themes
Support for SQL Server Management Studio 17
Export test execution results
SQL script
SQL database table
Pie charts
Test management
Customizable success thresholds
Disabling tests
History of test execution results
Setup stored procedure for each test class
Editable template for creating new tests
Sorting tests
Test markup in the Object Explorer pane
Package/deployment of a set of tests
ApexSQL Unit Test 2016 R2 Released ApexSQL Unit Test 2016 R3 Released ApexSQL Unit Test 2016 R5 Released ApexSQL Unit Test 2017 R1 Q4

ApexSQL Unit Test is part of the

ApexSQL CI/CD toolkit

Volume pricing

per user

1

$499

2-4

$399

5-9

$349

10-19

$299

Save a bundle

ApexSQL Unit Test is included in ApexSQL Developer

16 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 75% savings