SQL Test

If you want to do test-driven development for databases, SQL Test is the place to start.

It lets you write database unit tests in T-SQL and run them in SQL Server Management Studio.

Its simple to set up, you dont need extra tools, and you dont need to learn new technologies.

Key Features

• Write your tests in regular T-SQL: 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.
• Tests won't change your database: SQL Test stores its objects in a separate schema, so they wont get in your way. The tests run in transactions, which rolls back any changes. You wont need any clean-up code.
• Run as many tests as you want with one click: Pick your tests, click one button, and the SQL Test UI will display each result as it comes in.
• Test objects in isolation no need to worry about keys or IDs: 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.
• Includes example unit tests and SQL Cop: 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.