dean.giberson 64357 (10/7/2014)
...I think it would be great to have some automated way to do this testing but I can't think of a way that wouldn't require almost as much work to set up as it does to just test as you go...
Once people started using unit testing tools this very issue was resolved by the tools providers (amongst others). They "stole" ideas off of each other and drastically lowered the time it takes to write the tests. Also, tests being continuously run ensures that even after you leave your code your tests remain in place providing continuous value.
It just needs a push by a subsection of DBAs to drive this into common practice.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!