Red Gate logo

Do test-driven database development in SQL Server Management Studio

If you want to do test-driven development for databases, SQL Test is the place to start.

It lets you write database unit tests in T-SQL and run them in SQL Server Management Studio.

It’s simple to set up, you don’t need extra tools, and you don’t need to learn new technologies.

Try SQL Test free for 28 days

$369

per user

Buy now

Write your tests in
regular T-SQL

SQL Test uses the open-source tSQLt framework, a set of T-SQL tables, views, stored procedures, and functions.

Tests are simple queries which use the framework to check the values of your data types and to mock database objects.

Writing unit tests in T-SQL inside SQL Server Management Studio

Tests won't change your database

SQL Test stores its objects in a separate schema, so they won’t get in your way. The tests run in transactions, which rolls back any changes. You won’t need any clean-up code.

“Everyone is excited about SQL Test – it allows us to complete our agile test-driven development journey.”

Run as many tests as you want with one click

Pick your tests, click one button, and the SQL Test UI will display each result as it comes in.

Clicking Run Tests in the SQL Test drop-down menu inside SQL Server Management Studio

Test objects in isolation – no need to worry about keys or IDs

SQL Test comes with stored procedures for faking tables, triggers, and constraints. They make it easy to test your objects in isolation, without adding extra data for IDs or foreign keys.

Includes example unit tests and SQL Cop

SQL Test has built-in examples to help you get started, and SQL Cop tests to check for problems such as fragmented indexes, badly sized data types, and missing keys.

SQL Cop tests sitting inside the SQL Test tab in SQL Server Management Studio

Try SQL Test free

Download a fully-functional, 28-day trial of SQL Test.

Download SQL Test

Got a question?

If you'd like any help, or have any questions about our tools and purchasing options, get in touch.