Just a couple thoughts that might make maintaining things easier
1) Using a system like Mangos/Trinity does for displaying/logging the current rev/build at run-time. That way we know exactly what build we're running at all times. The genrevision code looks like it already handles pulling the version from SVN so it should be just a matter of putting it in the code and setting build order/pre-build event. (speaking as a vb developer of course)
2) The db_version table in the db. any reason why the column name is the rev of the db sourced? Wouldn't it make more sense to have the column named something like db_ver and then the data field for that be the rev #?
3) linked to #2, in that any sql updates should also update the db_version table. ie i had sourced peqdb_1129Rev384.sql, and then done all subsequent updates via svn through Rev438.sql. the db_version should show '438' but still shows '384'
just a couple thoughts - feel free to agree or pick 'em apart
A couple ideas
Linear Mode
