One of my workmates could only find relief from her migraines with a shot of Imitrex. I would maybe try the oral form first (if you haven't already) and then take it from there.

I'm sorry your job is so stressful. I would try to figure out a way to switch fields rather than continue if the stress is affecting your health to that extent. Like you yourself say, you are having a hard time functioning with your family and that can't go on and does them no good if you are that ill at this job. I don't know that you can find relief from the migraines if the stress continues unabated?