We are moving:
Download the newest version directly at tSQLt.org

tSQLt is a unit testing framework for Microsoft SQL Server. tSQLt is compatible with SQL Server 2005 (service pack 2 required) and above on all editions.

tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests. tSQLt also provides the following features to make it easier to create and manage unit tests:

* Tests are automatically run within transactions – this keeps tests independent and reduces any cleanup work you need

* Tests can be grouped together within a schema – allowing you to organize your tests and use common setup methods

* Output can be generated in plain text or XML – making it easier to integrate with a continuous integration tool

Project Samples

Project Activity

See All Activity >

Follow tSQLt - DB Unit Testing for SQL Server

tSQLt - DB Unit Testing for SQL Server Web Site

Other Useful Business Software

Monitor your Cisco ASA like an expert Icon
Monitor your Cisco ASA like an expert Icon

See how Network Insight™ for Cisco® ASA, a feature of SolarWinds Network Performance Monitor and Network Configuration Manager, can help.

Get visibility into the health and performance of your entire Cisco ASA environment in a single dashboard. View VPN tunnel status and monitor firewall high availability, health, and readiness. Automatically discover and filter within ACLs, show rule hit counts, and detect shadow and redundant rules. Automate the monitoring and management of your ASA infrastructure in a fully integrated solution. Try it free for 30 days!

Rate This Project

Login To Rate This Project

User Ratings

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

User Reviews

  • tSQLt brings SQL Server Development practices into the 21st century to become a fully fledged participant in agile methodologies including TDD, BDD and CI. It offers a good range of assertions and excellent mocking features. Never underestimate the value of the ability to isolate and test a single table that has multiple FK references to other tables which themselves reference other tables etc. without having to set up the data in all those referenced tables. tSQLt can also mock views, stored procedures and functions which means that we can write loosely coupled, discrete code modules that can be tested in isolation and will be easier to understand and maintain going forward. Also integrates well with many Continuous Integration tools. I honestly believe there is nothing else out there that come close to tSQLt.

Read more reviews >

Additional Project Details

Intended Audience

Developers, Quality Engineers, Testers

Database Environment

SQL-based, Microsoft SQL Server