SQL Test

SQL Test allows you to write unit tests for SQL Server databases in SQL Server Management Studio. 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, there is no need for 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.

SQL Test is an Add-in for SQL Server Management Studio that you can use to create and run unit tests against your databases.

  • 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. SQL unit testing runs through simple queries which use the framework to check the values of your data types and to mock database objects.
  • Tests won't change your database - SQL Test stores its objects in a separate schema, so...

Latest News

SQL Test v4.1.5
SQL Test v4.1.5
June 1, 2023New Version
Adds object filter for test procedures.
SQL Test v4.1.4
SQL Test v4.1.4
March 2, 2023New Version
Adds support for Microsoft SQL Server Management Studio (SSMS) 19 GA.
SQL Test v4.1.2
SQL Test v4.1.2
September 23, 2022New Version
Adds support for Azure Active Directory (MFA) authentication for connections.
SQL Test v4.1.x
SQL Test v4.1.x
April 29, 2020New Version
Adds support for SSMS 18.5.
SQL Test v4.0.x
SQL Test v4.0.x
December 18, 2019New Version
Now supports Azure SQL Database and Azure managed instances.
SQL Test v3.1.1
SQL Test v3.1.1
January 14, 2019New Version
Adds support for SSMS 18 and Microsoft SQL Server 2019.

Prices from: $ 276.21

One software license is required per user. Support and upgrades: For the duration of the purchased support period; 1 Year, 2 Years or 3 Years, you will receive: Free upgrades: when a new major version...

SQL Test is also available in:

Got a Question?

Live Chat with our Redgate Software licensing specialists now.

Redgate Software
As official and authorized distributors, ComponentSource supplies you with legitimate licenses directly from Redgate Software.
Add-in Type
  • SQL Server

Recent Awards

PublisherPublisherPublisher