If you're on a Java stack, use DbUnit; furthermore, the combo of Spring Test & DbUnit, and staying away from putting too much logic in stored procedures / trigg

If you're on a Java stack, use DbUnit; furthermore, the combo of Spring Test & DbUnit, and staying away from putting too much logic in stored procedures / triggers means you can unit test against the database fairly well -- leaving zero side effects, and with speed/efficiency. I wrote up a blog entry on the technique I use: http://zenoconsulting.wikidot.com/blog:8 http://zenoconsulting.wikidot.com/blog:8