ApexSQL Unit Test

SQL unit testing

Implement SQL unit testing directly from SSMS

• 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

Various ways to install the tSQLt framework

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

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