Our application has a large Microsoft SQL Server database with a lot of intelligence inside of it, many stored procedures, functions etc (I know the arguments, but it works for us, and isn't going to change). I am seeking a better tool to run a suite of automated regression/unit tests against the procedures.
I have been using the DBFit platform for a couple of years, and it works pretty well. It is fast, and easy to write and update tests. However it hasn't been actively updated in several years, and more and more tests break as we upgrade to new parameter types in the latest SQL Server versions that the tool doesn't support.
We have Visual Studio 2010 Premium, but when I investigated its SQL unit tests capabilities the execution seemed very slow, and it doesn't support the SET NO_BROWSETABLE statement which we need for application compatibility.
Who else is running automated SQL tests, and what are you using?
(cross posted from the Unit Testing forum, since I didn't get any responses there).
You can test just about anything in SQL server this way, especially if you are good with SQL. These examples use single lines of SQL, but you can send many lines separated by semicolons. I've done very complex stuff this way including using temporary tables to capture stored procedure output and join it against other tables, etc.
Chris R Mead
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.