Lets start with a couple of items that we should probably agree on before proceding with my mini rant.
Any developer worth their salt uses some sort of source control as part of their process. The more complicated the project the more critical source control is, right? A web project that is big enough to need stored procedures is probably fairly complicated, right? So why can’t I find any tools to dump schemas, split them up, and stuff them into something like subversion?!
Stored procedures can make a dramatic improvement in how much traffic a site can handle. So they will be used more and more by people that want to get the most out of existing hardware. Especially in the light of our current economy.
Unless I am missing some good tools that already exist, I will be working on my own tools to do this.
