SQL Test



 

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

Features
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 they won’t get in your way. The tests run in transactions, which rolls back any changes. You won’t need any clean-up code.

Run as many tests as you want with one click                                                                                                                                                  

Pick your tests, click one button, and the SQL Test UI will display each result as it comes in.

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

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

Includes example unit tests and SQL Cop                                                                                                       
 

SQL Test has built-in SQL Server unit testing examples to help you get started, and SQL Cop tests to check for problems such as fragmented indexes, badly sized data types, and missing keys.


 

DEMO/TRIAL


Free_Trail_icon


For Demos & Free Trials, Email us at info@redgate.sqlmaestros.com or
call us at +91 7829999044, +91 7829999045

Contact Us


We’d Love to Hear From You, Get In Touch With Us!

 SQLMaestros c/o eDominer Systems P Ltd. 686, 6 A CROSS, 3RD BLOCK KORAMANGALA, BANGALORE – 560034 +91 8041215205
    91 7829999044
    91 7829999045
                    info@redgate.sqlmaestros.com