What will I do for love?

I tend to be an serial long-distance relationship type. I don't intend on it ever, but within these relationships one party always has an amazing opportunity elsewhere, myself included. And eventually we decide to end the relationship.
So when my friend wanted to set me up with her friend that lives in Texas, I of course said 'hell no'. But thanks to social media he reached out and fireworks flew.
My first visit to Texas ended with 'So you'll move to NY in a year?' He smiled, said yes and kissed me.
Needless to say, plans change and 7 months later his business partner decided it was time they move forward with their plans.
He told me, I was devastated. I didn't shower for days and cried. Yes, that bad and I never thought I'd react that way. He was decidedly the person I want to spend the rest of my life with and now what?
I told him to stay in Texas- it's his dream job after all and I couldn't keep him from this, but what do I do? Four years of gaining friendships in the music, fashion and film industries, learning from the country's best, just to throw it away and become a suburban housewife? If you know me, you know that's not my style. But if I stay here it'd mean we wouldn't be together for years until his business grew and he could sell.
I've never come at such a crossroad.
The relationships have never been this serious. But I never in my dreams imagined myself in Texas.
I'm still at odds.