My situation: I recently migrated my company's old ordering system to a new one I developed for them. It had to be backwards compatible and work with the existing database structure until the migration was finally completed. Now that the migration is partially complete, I would like to redesign the database, but I find myself almost 100% of the time supporting the interface, and existing idiosyncrasies of the old database structure. I'm not given any time to document anything so updating anything requires me to rely on the comments I created when originally developing the application.
Not only do I now have to support it for every department, but it seems like even more projects are being thrown at me - which are all getting triaged, and some take weeks before I can even look at them. I hate to do sloppy work in order to get everything done, but it seems like that's where I'm headed :(
I was wondering (and hoping) if anyone is/was in a similar situation and share their insight and perhaps give me some idea's before I rip my hair out :)