How can we help you today? How can we help you today?

Unit testing in VS/TFS

In some of our upcoming projects we are required to implement automated unit testing for some of the database objects.

It seems that the only way to implement unit testing against DB objects in VS 2001 is to create a database project.

Since SQL source control cannot interface with this project type, is there anyway of implementing a unit test against the scripts that SQL source control generates? Or is there a way of interfacing with the database project that i am missing?

Thanks a lot.

Steve
Nicon
0

Comments

4 comments

Sort by
  • David Atkinson
    Thanks for your question.

    Database project support is an increasingly popular request. If this is something you'd like to see, please vote for it at:

    http://redgate.uservoice.com/forums/390 ... ?ref=title

    In the meantime we're recomment using NUnit or a similar framework to test your database code in the same way that you test your .NET code.

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • Nicon
    Great, thanks for the advice.

    I have already voted! :D
    Nicon
    0
  • David Atkinson
    Steve,

    If you're still interested in unit testing your SQL objects, maybe SQL Test might be something you could use?

    http://www.red-gate.com/products/sql-de ... /sql-test/

    I'd be interested to get your thoughts on this.

    David
    David Atkinson
    0
  • Nicon
    Thanks for that David.

    Looks like what we were after.

    I will get it installed and then let you know my thoughts.

    Regards

    Steve
    Nicon
    0

Add comment

Please sign in to leave a comment.