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
* Provides the ability to fake tables and views, and to create stored procedure spies – allowing you to isolate the code which you are testing
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.
Great software, thanks tsqlt
Great software, thank you.
tsqlt works nicely