Unit testing in VS/TFS

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Unit testing in VS/TFS

Postby Nicon » Wed Jul 06, 2011 10:09 am

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
 
Posts: 4
Joined: Wed May 25, 2011 2:48 pm
Location: Staines

Postby David Atkinson » Thu Jul 07, 2011 11:15 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Nicon » Thu Jul 07, 2011 11:16 am

Great, thanks for the advice.

I have already voted! :D
Nicon
 
Posts: 4
Joined: Wed May 25, 2011 2:48 pm
Location: Staines

Postby David Atkinson » Thu Nov 24, 2011 7:49 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Nicon » Fri Nov 25, 2011 9:11 am

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
 
Posts: 4
Joined: Wed May 25, 2011 2:48 pm
Location: Staines


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests