SQL Test Brings tSQLt Unit Testing to SQL Server Management Studio

Posted by Jenni Konrad on Dec 15, 2011

Sections

Process & Practices,

Development

Topics

SQL Server ,

Unit Testing ,

Relational Databases ,

Microsoft ,

Agile ,

Database ,

Companies ,

TDD ,

Testing ,

T-SQL ,

tSQLt

Share |

RELATED Research

Red Gate has released SQL Test, a unit testing add-in for SQL Server Management Studio. It allows developers to create and run unit tests from within SSMS, and share them with other team members.

SQL Test is the user interface for tSQLt, the open source unit testing framework for SQL Server. tSQLt allows for the creation of test cases using T-SQL. These test cases are collected into a test class, which is a special schema used by the framework. Testers can use tSQLt to create fake tables and views, populate them with test data, and compare actual versus expected results. (All of the tests are executed within transactions, to allow for easy cleanup.) tSQLt also promotes Agile development by supporting continuous integration tools like Team Foundation Server and CruiseControl.

SQL Test provides a graphical front-end for tSQLt. The SQL Test window allows users to more easily create test classes, view existing unit tests, execute them, and view the results with in a dockable panel in SSMS.

SQL Test is compatible with SQL Server 2005 onward, and comes with a sample database with pre-configured unit tests. More information is available from Red Gate.

RelatedVendorContent

The Agile Tester

Introducing SQLFire: a memory-optimized, high performance SQL database

Automating Error Reporting for .NET Applications

Tools to unit test your JavaScript

Combining Inspections, Static Analysis, Testing to Achieve >95% Defect Removal Efficiency

Related Sponsor

In today’s hyper-competitive world, later may be too late to adopt Agile development and this Roadmap for Success will help you get started. Download "Agile Development: A Manager's Roadmap for Success" now!