I'm looking to create a batch of automated tests in SQL on MS-SQL server, these will include tests like - insert some records, call stored procedure, check certain conditions in various tables. There will be other tests which will just be complicated queries - ie. many look like unit tests but will include deep knowledge of the product.
It would be helpful if these tests could be run on a customer site as well as in the office with minimal interference and maximum portability.
I was thinking of just going down the route of a stored procedure for each test and writing out detailed text as the results for each FAIL, and just a "Test number 99 - PASS" otherwise.
Would a more formal / commercial test harness be helpful? Thoughts?