USD
Home › Shop › Red Gate › SQL Test
Red Gate
SQL Test - New Subscription 12 Months / 10 - 10 User(s)
⚡ Free electronic delivery in 1–3 working days
✓ Official licences direct from 1000+ software vendors
⇄ Invoice payment for companies & the public sector, in CHF, USD or EUR
Red Gate · SQL Server

SQL Test

New Subscription 12 Months

Redgate SQL Test is an add-in for SQL Server Management Studio that lets you write and run unit tests for SQL Server databases in T-SQL.

Product type
Quantity
10 - 10 User(s)
1+ User(s)
5 - 5 User(s)
Number of licences
Minimum order quantity - 10
SKU SKU-113
2,430.00 USD
International price · including 0% VAT
Volume pricing on request Swiss distributor based in Rüti ZH
Can't find what you are looking for? Contact us through chat widget, support form or email

About this product

SQL Test by Redgate is a unit testing tool for SQL Server databases. You write tests in T-SQL and run them directly in SQL Server Management Studio (SSMS), and you can also run them in automated builds. This lets you catch defects in database code during development instead of in production.

SQL Test is built on the open-source tSQLt framework. Tests run inside transactions that roll back every change, and test objects are kept in a separate schema, so you don't need cleanup code. Stored procedures can fake tables, triggers and constraints, which lets you test individual objects in isolation. You can start multiple tests with one click and see each result as soon as it finishes. The included SQL Cop tests run static analysis and check for issues such as fragmented indexes, poorly sized data types and missing keys. Example tests help you get started.

Who it is for

  • Database developers who want to test stored procedures, functions and triggers
  • Teams that add database tests to their build and release processes
  • Database administrators who want to enforce best practices with static checks

Licensing

SQL Test is licensed per user on a subscription basis. The shop offers new subscriptions with 12-, 24- or 36-month terms. You can buy a licence for a single user or packs for 5 or 10 users. The software runs on Windows, and the licence covers the English version.

Delivery

Delivery is electronic (ESD). Your licence key and download details are sent by email once your order has been processed.