Unit testing in VS/TFS

[Nicon]

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

[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/39019-sql-source-control/suggestions/1010465-work-with-a-visual-studio-2010-database-project?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

[Nicon]

Great, thanks for the advice.

I have already voted!

[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-development/sql-test/

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

David

[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