Chronic pain and TTC

Hello everyone!
My husband recently decided to TTC for the first time and I suffer from Chronic Migraines. Up until a few days ago I took Excedrin every day. For my health and the health of any future children I decided to stop taking Excedrin cold turkey and was met with excruciating pain. I went to Urgent Care today to try to get some advice and the doctor told me he doesn't think I should ever try to have children as my migraines will only get worse. I have always seen myself as having a baby some day and I was crushed when he told me. Of course I'm going to talk to my doctor as soon as possible and I will be seeing a neurologist to try to get some relief from the pain. But has anyone else successfully managed pregnancy and chronic pain? Or should I just accept it may not be the best choice for me?