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

ApexSQL Redgate®
SQL Server version
      SQL Server 2005 - 2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Amazon RDS for SQL Server 2019
Integration
      SQL Server Management Studio (SSMS)
SQL unit testing
      Demo kit database with predefined unit tests
      Get messages about passed and failed SQL unit tests
      Manage all SQL unit tests from within a single form
      Multi-selection of unit tests in the "Unit test explorer" tab
      Organize SQL unit tests in test classes
      Run SQL unit tests under one class with a single click
      Run SQL unit tests with a single click
      SQL Cop tests
      Stop SQL unit test execution at any time
      Test status indicators
      Code coverage
      Customizable success thresholds
Export
      XML
      SQL database table
      SQL script
Interface
      Command line interface
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects
Price
$499 $365

ApexSQL Unit Test 2018.01

Redgate® SQL Test 3.0.5.451


Comparison was conducted on August 14, 2018

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

Volume pricing

per user

1

$499

2-4

$399

5-9

$349

10-19

$299

ApexSQL Unit Test is part of the

ApexSQL DevOps toolkit

Save a bundle

ApexSQL Unit Test is included in ApexSQL Developer

All 20 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 80%+ savings