Automation Testing of Stored Procedures in SQL Server

[b***@gmail.com]

Hi, I am a newbie in SQL. I use SQL server for database management in my company. I am assigned task to automate the manual testing of business rules/stored procedures. I am searching for a method which is generic for automating any business rule testing (There are hundreds of business rules). Can somebody suggest me which technology is best suited for this ? Also what could be a better choice between TSQL and DBUnit for this task ?

[p***@gmail.com]

Hi, I am a newbie in SQL....

I've just started using tSQLt (http://tsqlt.org/) for automated testing of Stored Procs. It's fake tables and views are very proving very helpful. It does create a lot of schema objects itself within the database under test, but our Source Control (RedGate) is able to distinguish and ignore them for the purposes of source control if necessary.

Regards,

Paul Logan.