What is SQL Test?

SQL Test is the user interface for tSQLt produced by Red Gate. It is fully integrated with SQL Server Management Studio and makes writing and executing tests an ingeniously simple process!

SQL Test is the fastest way to get started with SQL Server unit testing. You can easily add tSQLt to your database and start writing tests immediately! The UI displays all your tests and their results in a handy dockable panel.

What is tSQLt?

tSQLt is a unit testing framework for SQL Server. It provides the APIs to create and execute test cases, as well as integrates them with continuous integration servers (such as CruiseControl, TFS and Bamboo).

tSQLt is designed with many unique features which make it easy to maintain tests. It supports the following aspects of good unit testing:

• 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 mock out tables and stored procedures – allowing you to isolate the code which you are testing

As an open-source project, tSQLt is free to use and modify. The complete code base is available on SourceForge.