Write unit tests for SQL Server databases in SQL Server Management Studio
If you want to write unit tests in T-SQL and run them as part of your automated builds, SQL Test is the place to start.
It's simple to set up, you don’t need extra tools, and you don't need to learn new technologies.
SQL Test also comes with pre-written SQL Cop tests, to help you enforce best practices for database development and run static analysis tests.Try SQL Test free for 28 days
SQL Test uses the open-source tSQLt framework, a set of T-SQL tables, views, stored procedures, and functions.
Tests are simple queries which use the framework to check the values of your data types and to mock database objects.
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.
“Everyone is excited about SQL Test – it allows us to complete our agile test-driven development journey.”
Pick your tests, click one button, and the SQL Test UI will display each result as it comes in.
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.
SQL Test has built-in 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.