Ugh. I'm glad your son is okay. I had crippling migraines for 20 years. So I guess he really isn't okay but at least migraines only ruin your life slowly.
Triptans. I tried a lot of them and settled on Maxalt - it melts on the tongue and works fast. Really expensive.
I had to take several prophylactic daily meds to try to mitigate the number of migraines I got. So many side effects.
They tell me my paternal grandfather used to get "sick headaches" too. I bet they were migraines. He would have to retire to a dark room just like I had to.