Being used to do Unit Testing in most of my regular code, I want to do the same for SQL Server code.
Target is SQL Server 2000 and up (since I’m involved in a big migration project getting a lot of SQL Server 2000 data and code to be upgraded to SQL Server 2012 or SQL Server 2008 R2).
Here are a few links that are on my research list:
- TSQLUnit on sourceforge.
- Close these Loopholes – Reproduce Database Errors.
- T.S.T. the T-SQL Test Tool on CodePlex.
- tSQLt – Database Unit Testing for SQL Server.
- Scarlet & Scary : Unit Testing TSQL.
- sql server – Unit Testing TSQL – Stack Overflow.
–jeroen