I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros
, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop
. This should be considered the official repository for the code from this point forward.
We encourage others to work with the project, which is built on the tsqlt framework. Code quality has become an important part of software development, and it should be a regular part of your database development routine along with other types of testing.
You can read about how to start using SQL Cop with SQL Test, and then how to start writing your own tests for code. There are a couple articles and blogs that you might want to read:
We also encourage you to contribute to the project if you find ways to enhance existing tests, or you find new tests that are useful in increasing the code quality of your projects. We have an article at SQLServerCentral that describes how to make changes to a test and submit a pull request on GitHub.
About SQL Cop
The SQL Cop project was developed by George Mastros as a way to perform database tests that help improve code quality and standards. The idea was to use the tsqlt framework to highlight potential issues in a SQL Server database. It has become very popular and is integrated into the SQL Test
add-in from Redgate Software.
The tsqlt framework is designed to be a unit testing framework for SQL Server databases. Tests are written in T-SQL, and managed as stored procedures.
You can find out more information at tsqlt.org