SQL Test - SQL Server Unit Testing Tool From Redgate

Write unit tests for SQL Server databases in SQL Server Management Studio

Introduction to SQL Test

If you want to do SQL Server unit testing in T-SQL, and run it as part of your automated builds, SQL Test is the place to start.

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

SQL Test also comes with pre-written SQL Cop tests, to help you enforce best practices for database development and run static analysis tests.

Try SQL Test free for 28 days

Features

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 SQL Server unit testing 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

Part of our Database DevOps solution

Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.

From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We give you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value and keep your data safe.

Learn more about the benefits