• I spent most of the day researching TSQL Unit for the company I work for.

    We are moving towards test-driven development and we are looking for a way to run data validation scripts as part of the development process.

    Here are some of the pros and cons I found with this product.

    Pros:

    1. Easy to implement tests

    2. Can run a test from the command line or from an application

    Cons:

    1. Have to create their tables and stored procedures on every database you want to test.

    2. Their stored procedures are using CURSORS!!

    3. Have to store your test stored procedures in the database.

    4. Not recommended for use on a Production Environment.

    So basically, I have recommended against T-SQL Unit.

    I feel that there are better ways to unit test stored procedures, many of which were mentioned above.

    This product is definitely not useful for running data validation scripts.

    (BTW, if anyone knows of a good way to do that please pass it along :).)