I've had migraines for years. The best Rx for me is Imitrex. I also take antidepressents which somehow cut down on the amount of migraines I get and many people have the same experience. My antidepressants are called Immipramine, but there are about 50 different kinds to try.
Over the counter, the best for me is a double dose of Motrin/ibuprofen (ask your doc, you can't double it up all the time or you'll get liver damage or something) You have to take it right away.
Other ideas: If you catch it right in the beginning like if you get sparkles in your eyes (aura) or you feel nauseous, put an ice pack or a cold wet washcloth on the back of your neck and relax in any way that works. stay away from sounds and smells. And, I'm not the only person who swears that Vanilla Bean by Haagen Daz really helps. You need a little size and just eat it from the fridge. It has to be very cold so the pint size or whatever keeps it the right temp. The smell of the vanilla or the coating of your stomach along with the cold in the back of your throat will help you. worth a try.
If you can sit in a relaxing lazyboy type of chair, eat hagen daz (has to have the little vanilla particles) with an ice pack on the back of your neck...sometimes that will really work. If you can get tylenol with codeine (try Canada if you can get it over the counter in most places) and that often helps without knocking u out.
ps if your dr will give you trials of diff antidepressants, they have a pain-numbing effect on many people. You need to take them prophyllactically (every day to prevent the problem). A very small dose might do the trick. That and keeping Imitrex in my purse day and night is the only thing that has worked.