Where to move...?

My bf lives in North Carolina because he's in the army there. We are both from Los Angeles, I'm still here. He asked me if I'd consider moving to n.c. and honestly I don't think I can. I know the cost of living there is so much better than L.A. but I feel like there's nothing for me to do over there. I'm such a city person and I have more job opportunities here also both of our families are here too. And if I ever had kids it would break my mom's heart if she couldn't be around them ..

he says ok but I can tell he's a little upset.

What would be a good compromise? I was looking at cities in northern California but I'd like to hear any other options or suggestions.

Thanks.