SQL Test 4.1

SQL Test by Red Gate Software Ltd. is a unit testing tool for Microsoft SQL Server that brings automated testing to your database code. Built on the open-source tSQLt framework and integrated into SQL Server Management Studio (SSMS), it lets you create, run, and manage tests for stored procedures, functions, and triggers with minimal setup. With clear, immediate results and test isolation, you can catch regressions early and refactor with confidence.

Key features:

• SSMS integration: Create, organize, and run tests without leaving your development environment.
• tSQLt-based: Write tests in T-SQL using proven patterns like faking tables, asserting outcomes, and cleaning up fixtures.
• Fast feedback: Run a single test, a test class, or the entire suite, and view pass/fail status, messages, and execution times at a glance.
• Test scaffolding: Use helpers and templates to set up test classes and test procedures quickly.
• Collaboration and source control: Store tests as T-SQL scripts alongside your schema changes for easy versioning and code review; works well with SQL Source Control and similar tools.
• CI/CD friendly: Execute tSQLt tests from build scripts or pipelines to prevent breaking changes from reaching production.
• Safer refactoring: Validate behavior before and after changes to database objects to ensure consistent results.

Who it’s for:

• SQL Server developers and DBAs who want reliable, repeatable tests for T-SQL code as part of modern development and DevOps workflows.

SQL Test is developed by Red Gate Software Ltd. and is used by 12 users of Software Informer. The most popular versions of this product among our users are: 1.5 and 4.1. The names of program executable files are RedGate.SharedSSMS.IdeLauncher.exe, RedGate.SQLTest.IdeLauncher.exe.