Boyfriend is leaving

I need some help or inspiration from anyone who has gone through this. My boyfriend and I have been together almost 4 years, his entire family lives in Ohio and mine is here in Arizona. He has been here in Arizona for 5 years. Just two weeks ago his job put out that he was up for a promotion, which is great, the only downfall is that he would have to move to Ohio. He told me that he really wanted the promotion, but would not take it if I did not want him to. I told him that it’s a great opportunity and I shouldn’t be the one to stop him from that. Long story short he got the promotion, and has to leave by October 6th. I unfortunately can not go with him because I am in a lease and working on getting certifications that will help me in my career. How do you make a long distance relationship work? I love him with every bit of my soul and we would like to get married eventually just not right now due to financial reasons. How hard was it to make the relationship work long distance? How do you stop from feeling so alone and heart broken? Someone please help me, I’m completely heart broken but so happy for him for the opportunity he gets.