Regression tests for T-SQL stored procedures

Posted by Achim on Stack Overflow See other posts from Stack Overflow or by Achim
Published on 2010-05-21T13:25:12Z Indexed on 2010/06/01 19:43 UTC
Read the original article Hit count: 401

Filed under:
|

Hi,

I would like to regression test t-sql stored procedures. My idea is to specify for each SP multiple input parameter sets. The SP should be executed with these parameters, results should be written to disc. Next time the new results should be compared with results stored before.

Does anybody know a good tool for something like that? Should not be that hard to implement, but in practice you will need functionality like "ignore that column" or something like that. And I would assume that such a tool should already exist!?

cheers, Achim

© Stack Overflow or respective owner

Related posts about testing

Related posts about t-sql