Micah
Micah

Reputation: 116170

Unit Testing Stored Procs

I have some pretty important stored procs that I want to setup automated tests for. I'm using VS2010, Sql Server 2008, MSTest, TeamCity, and PSake. Are there any great tools or frameworks out there that do this?

Upvotes: 0

Views: 164

Answers (2)

Kuberchaun
Kuberchaun

Reputation: 30372

I would check out Java and look into JUnit or TestNG. There are some really rich frameworks out there any they tie into TeamCity really great.

Just an option I realize you might be tied to VS2010.

Upvotes: 0

kenwarner
kenwarner

Reputation: 29130

it's a little outdated, but http://blog.coryfoy.com/2007/07/test-driving-stored-procedures-in-sql-server-in-vs2008/ gave me a good starting point when i was doing this

Upvotes: 1

Related Questions