I am not sure of the statistics but lets say 10% of the population suffer from migranes, less than 1% of pilots do. Or more accurately admit to it. A friend of mine who suffered admitted to one to his doctor and had his single pilot rating removed for a year. A bit unfortunate as he was flying commercially in a single crew twin. Fortunately he kept his job and his hours going though use of a safety pilot on trips that allowed the extra weight. I have no idea of medication suitable as I fortunately don't suffer and I don't know how it would affect a class two medical. The best you can do is work out what the trigger is for your migranes (caffeine, cheese, uv light, dehydration etc etc) and avoid it. This is one of those things that is generally avoidable by a slight lifestyle change. Good luck.