423 downloads Updated: Jul 17th, 2018 Trial   
4.0/5 1






  100% CLEAN   report malware

ApexSQL Unit Test icon Perform unit tests for your databases inside Microsoft SQL Server Management Studio, then manage tests, classes and database content

Keeping database applications working and maintaining their quality requires a continuous effort. To help developers in this regard, ApexSQL Unit Test integrates SQL unit testing into SQL Server Management Studio (SSMS), enabling developers to create and run new tests much easier.

Fast deployment and SSMS integration

Deployment is easy and a new menu named ApexSQL is added to SQL Server Management Studio. However, you can only access the Options to configure the application's behavior from there.

New tests cannot be created until you install tSQLt on your computer. ApexSQL Unit Test makes sure you always get the latest version of the open-source unit testing app. You can reinstall or update tSQLt anytime you want to, from the same menu.

Create new unit tests with ease

Creating new tests and running existing ones is easily done using the right-click menu in the 'Object Explorer'. To generate a new unit test, you must provide it a name and select the test class you want it to use.  ApexSQL Unit Test comes with a collection of ready-made SQL Cop tests you can run without having to create them manually. All the tests you create are stored as procedures inside the target database.

The generated SQL file is previewed in SQL Server Management Studio, taking advantage of the powerful editor SSMS comes with. The template is automatically generated, and you just have to fill it in with test statements and details about the database you are testing. Tests are executed as stored procedures, and the result can be 'pass' or 'fail'.

Add unit testing capabilities into SSMS

ApexSQL Unit Test helps you create unit tests in SSMS, run tests and export the results. It provides advanced test management tools and CLI support for automation of tasks, making database management much easier.

Unit test Database maintenance Database test Test Database SQL cop TSQLt

ApexSQL Unit Test was reviewed by Mihaela Teodorovici
  Click to load comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

ApexSQL Unit Test 2018.01.0131

add to watchlist send us an update
  file size:
16.8 MB
  runs on:
Windows 10 32/64 bit
Windows 2008 32/64 bit
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit
  main category:
  5 screenshots:
Apex SQL Tools
  visit homepage