BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

SQL Test Brings tSQLt Unit Testing to SQL Server Management Studio

by Jenni Konrad on Dec 15, 2011 |

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.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT