SQL Test

What is SQL Test?

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

If you want to take 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 apply best practices for database development and run static analysis tests.

Write your tests in regular T-SQL

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

SQL unit testing is performed through simple queries that use the framework to check the values of your data types and to simulate database objects.

Tests won't change your database

SQL Test stores your objects in a separate schema so they don't get in the way. Tests are run on transactions, which rolls back all changes. You won't need any cleanup codes.

Run as many tests as you want with one click

Choose your tests, click a button, and the SQL Test UI will display each result as soon as it arrives.

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

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

Includes unit test samples and SQL Cop

SQL Test has built-in SQL Server unit test samples to help you get started, and SQL Cop tests to check for issues such as fragmented indexes, poorly sized data types, and missing keys.

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768