Redgate SQL Test

SSMS add-in for database unit tests
Buy now Contact

Publisher

Red Gate Software

Subcategories

Testing & QA

Average rating

Deze score is berekend door AI op basis van publiek beschikbare informatie.
4.4 / 5

About this software

SQL Test is an SSMS add-in for creating, running, and managing T-SQL unit tests using the open-source tSQLt framework. It installs tSQLt into a selected database, runs tests in transactions that roll back changes, and stores test objects in a separate schema. The tool includes example tests, static-analysis SQL Cop checks, and a code coverage view, aimed at database developers and teams needing integrated unit testing inside SQL Server Management Studio.

Purchase

Redgate SQL Test

Redgate SQL Test
In Stock
Delivery: 1 working day
Loading...
€290.64
Free and without obligation

Do you need more information or looking for another license?

envelope Get in contact phone Call me calendar Schedule a meeting

Benefits

  • SSMS integration: Run and manage tests inside SQL Server Management Studio.
  • tSQLt framework: Uses the open-source tSQLt framework for T-SQL unit tests.
  • Transactional test runs: Tests run inside transactions and roll back any changes.
  • SQL Cop checks: Includes prewritten SQL Cop static-analysis tests for common issues.
  • Code coverage reporting: Shows statement-level code coverage for tested database objects.

Available languages

  • English

Support information

  • Product documentation: Comprehensive user guides and tutorials are available on Redgate's documentation site.
  • Community forums: Ask questions and find solutions via Redgate forums and the tSQLt community channels.
  • Release notes: Release notes and version history are published on the product documentation pages.
  • Installation guidance: Installation instructions for adding SQL Test to SSMS are provided online.
  • Purchasing and licensing: Licensing details and multi-user discount information are managed through Redgate sales channels.

Frequently asked questions

What is Redgate SQL Test used for?
A tool for creating and running unit tests for SQL database code, helping validate stored procedures, functions, triggers, and queries and detect regressions during development.
Which database objects can be tested with Redgate SQL Test?
Common targets are stored procedures, functions, triggers, views, and ad-hoc queries; tests focus on functional behavior and expected results.
Can Redgate SQL Test be included in automated CI/CD pipelines?
Yes. Database unit tests can be run as part of automated build and deployment workflows; integration details depend on the CI/CD tooling and environment.
How are test results presented and used?
Test runs typically report pass/fail status and error messages to aid diagnosis; results can inform bug fixes, refactoring, and release decisions.