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