SQL Test v1.5 released

SQL Test allows you to write unit tests for SQL Server databases in SQL Server Management Studio. If you want to do SQL Server unit testing in T-SQL, and run it as part of your automated builds, SQL Test is the place to start. It's simple to set up, there is no need for 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.

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. SQL unit testing runs through 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 won’t get in your way. The tests run in transactions, which rolls back any changes. You won’t 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 SQL Server unit testing 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.

About Red Gate Software

Since 1999, Red Gate Software has been developing tools that simplify the business of working with SQL Server, .NET and Exchange. Its tools, which include SQL Compare, SQL Backup and ANTS Performance Profiler, have become industry standards for developers and DBAs worldwide. It counts Microsoft, HP, Sage, Bank of America, AT&T, The US Treasury and over 100,000 other leading organizations as customers. There are over 500,000 Microsoft technology professionals currently using Red Gate products.