> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Unit Testing Tool for SQL Server
- URL: https://nolongerset.com/unit-testing-tool-for-sql-server/
- Published: 2021-09-29T01:13:31.000Z
- Updated: 2026-05-08T13:02:09.000Z
- Description: This open-source database unit testing tool should help make test-driven database development easier to manage.
- Author: Mike Wolfe
- Tags: SQL Server, Testing, #Import 2026-05-20 02:59

You have to learn to crawl before you learn to walk...but eventually we all want to run.

My [recent series of articles](https://nolongerset.com/tag/vba-to-t-sql-via-tdd/) on Test Driven Development with SQL Server was all about helping you learn to crawl. If TDD was a completely new concept for you, I wanted to take you through the process one step at a time. Once you understand the concept, though, you will soon find that the manual steps get tedious. 

Having learned to walk, you now want to learn how to run.

## Get Running with tSQLt

If you want to apply the TDD concept on a larger scale, you will want a framework that takes care of the tedious parts of the process.

Big thanks to reader B.C. for introducing me to such a framework for testing in SQL Server. Here's an excerpt from [B.C.'s comment](https://nolongerset.com/vba-to-tsql-via-tdd-step-7/) (emphasis added):

> Is there a reason why you wouldn't want to use a **testing framework like tSQLt?**

To be completely honest, I had never heard of tSQLt before reading that comment. I have since looked at the [project website](https://tsqlt.org/) and it looks like a great tool for unit testing SQL Server. I still haven't used the project, but it's got official backing from premier SQL Server toolmaker [Redgate](https://www.red-gate.com/products/) (which lends it some major credibility).

Here are some quick links to get started:

- [Download tSQLt](http://tsqlt.org/downloads/)
- [Quick Start Guide](https://tsqlt.org/user-guide/quick-start/)
- [Full User Guide](https://tsqlt.org/full-user-guide/)

If you try it out (or if you're already a user), let me know your experience with it in the comments below.

---

### External references

[tSQLt - Database Unit Testing for SQL ServerDatabase Unit Testing for SQL Server![](https://tsqlt.org/wp-content/plugins/tsqlt_plugin/images/favicon.gif)tSQLt - Database Unit Testing for SQL Server![](https://s0.wp.com/i/blank.jpg)](https://tsqlt.org/)

[All Redgate’s Products For SQL Server, .NET, And OracleBrowse a full list of Redgate’s tools for SQL Server, Oracle, .NET, and MySQL.![](https://www.red-gate.com/favicon-192x192.png?v=1579259208499)Redgate logoRed Gate Software Ltd![](https://cdn.rd.gt/assets/images/global/redgate-og.png)](https://www.red-gate.com/products/)

### Referenced articles

[VBA to T-SQL via TDD - No Longer SetIn this series of articles, I go step-by-step explaining how you can re-write VBA functions as SQL Server scalar functions to increase performance without the risk of introducing logic errors during the migration.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/09/Overview-1.png)](https://nolongerset.com/tag/vba-to-t-sql-via-tdd/)

[VBA to T-SQL via TDD: Step 7Step 7\. Execute the test query in SQL Server to verify it fails![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/09/Step7.png)](https://nolongerset.com/vba-to-tsql-via-tdd-step-7/)