Yes were replacing stored procedures. First (as the app is partioned into logical components), we pick a chunk and move it to schema generation with hibernate.

Yes were replacing stored procedures. First (as the app is partioned into logical components), we pick a chunk and move it to schema generation with hibernate. Then we port the stored procedures to code with tests, then we delete all the stored procedures. We've gone from 0 test cases to 82,000 test cases in 6 years (we have 80 people in our developer pool so this is not some one man effort). For ref, I inherited this mess (mainly vb6/com) and am responsible for replacing it all.