Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLCop tests for tSQLt

The Redgate tool SQLTest for SQL unit testing now offers the ability to add tests from SQLCop however the Redgate tool only comes with few of those tests prebuild.

Since tests are just stored procedures I am sure somebody has implemented more of those tests.

Are you willing to share? Anyone?

like image 286
lstanczyk Avatar asked Mar 27 '12 22:03

lstanczyk


People also ask

What is SQL cop?

Welcome to the SQL Cop repository! These are a set of tSQLt tests designed to allow you to detect common problems in your database, originally maintained by George Mastros on LessThanDot. This project is now managed by SQLServerCentral and Redgate Software.

What is tSQLt?

tSQLt is a unit testing framework for SQL Server. It provides the APIs to create and execute test cases, as well as integrates them with continuous integration servers (such as CruiseControl, TFS and Bamboo). tSQLt is designed with many unique features which make it easy to maintain tests.


1 Answers

I wrote SQLCop. I've been working with the fine folks over at Redgate. Originally I provided 5 (or so) tests as a proof of concept. Since then, I have also provided the remaining tests that are included with SQLCop. You should expect the remaining tests to be included in their next release of SQL Test.

like image 59
George Mastros Avatar answered Oct 02 '22 22:10

George Mastros