Is there any testing tool available to test SQL proc / functions

  • Hi friends,

    Is there any testing tool available for the testing of SQL Stored procedures/functions? . Like the Nunit testing , NAND for .Net code I'm looking for some testing tool for SQL.

    Thanks in advance.

    Thanks & Regards,
    MC

  • Hi,

    we are testing our procedures with Visual Studio 2010. It has the Capability to write Unit tests for SQL procedures without programming C#.

    First you need to create a database project in which you can import your database creation script to save the database model in the database project. After this you can go to the Schema View and choose the procedure for which you want to create an unit test and click Create Unit Test ... . Now you will be asked whether you want to create a new Unit Test Project or add it to an existing Project.

    In this Unit Test Project VS will create a simple execute-statement for you proc and there you can add your specific unit testing code.

    This is a really helpful thing if you use all the microsoft technologies. 🙂

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • only4mithunc (4/17/2011)


    Hi friends,

    Is there any testing tool available for the testing of SQL Stored procedures/functions? . Like the Nunit testing , NAND for .Net code I'm looking for some testing tool for SQL.

    Thanks in advance.

    I've been playing with DBFit (http://www.sqlservercentral.com/articles/Testing/64636/) and I mostly like it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply