I followed DH (BF at the time) down here to SC from MI in 1985. We got married a year later. My folks were thrilled (and I'm an only child) probably because I was way too old to still be living at home!! My DH's family was sad, I'm sure, but didn't show it. We got complete support from both sides. We get to see his family about once every year or so. My folks moved here about 4 years ago.
Now let me tell you another story. My DH's brother (in MI) was going to be phased out of his job, so he took a job in San Francisco. His wife had visited there with him and seemed to be thrilled to go, even though she was leaving a very close knit family of siblings, and a son who had disowned her(he is just plain evil..). At her going away party, after she was already having really serious doubts about moving away, her best friends kept going up to her in-laws say, "I can't believe that ___ is taking her away from us. She should stay here..." and on and on like that. This was very upsetting to DSIL, and my inlaws, too. What kind of people are her friends???
Anyway, she made the move, and was miserable. It's been a year, and I think she is still miserable, but doing better. Her DD is doing great, very popular, award winning cheerleader, DH is doing well, too. She is a SAHM, and a very talented artist, so slowly she is meeting people through that....
Her friends and family did not help this matter at all.