Database / BI related unit testing options
A quick list of frameworks available for doing unit testing, based on what I covered in today’s SQL Lunch
MSFT
Database projects
Purpose: unit testing database objects
Method: SQL / GUI
Site: http://msdn.microsoft.com/en-us/library/jj851200(v=vs.103).aspx
Cost: Free
Pros: Built-in, quite well documented
Cons: Requires Visual Studio 2010 Pro or above
Codeplex
ssisUnit
Purpose: SSIS unit testing
Method: XML / GUI
Site: https://ssisunit.codeplex.com
Cost: Free
Pros: Unique
Cons: As of writing, only stable version was released in 2008
BI.Quality
Purpose: unit testing of outputs/results
Method: XML / GUI
Site: http://biquality.codeplex.com/
Cost: Free
Pros: Well documented, comprehensive
Cons: No recent commits
unitTestSSRS
Purpose: SSRS unit testing
Method: XML
Site: http://unittestssrs.codeplex.com/
Cost: Free
Pros: Unique
Cons: Documentation isn’t great, no recent commits
Others
tSQLt
Purpose: database object unit testing
Method: SQL query execution
Site: http://tsqlt.org/
Cost: Free
Pros: SQL, extensive, great documentation, well supported, open source
Cons: No GUI
SQL Test
Purpose: database unit testing
Method: GUI / SQL
Site: http://www.red-gate.com/products/sql-development/sql-test/
Cost: £225 per user
Pros: GUI, uses tSQLt, has SQL Cop for testing some bad design practices
Cons: Costs money
BI-xPress
Purpose: SSIS unit testing
Method: GUI / SQL
Site: http://pragmaticworks.com/Products/BI-xPress
Cost: ~£600 per user
Pros: GUI, extensive, lots of other features
Cons: Costs money