A military relationship can be very tough and it takes special people to make them work. I think the ones that work out best are the ones where the non military member is a independent person, who is confident in their abilities and self. They must cope with their loved one working long shift,s missing holidays and other family events and being gone for weeks or sometimes a year at a time.
My son graduated Boot camp in March. For those eight weeks I was on pins and needles wondering how he was and if he was ok. I'm a USAF veteran who knew what to expect and I'll tell you even I was emotional so its ok to have your feelings, just don't let them over take you.
Don't be afraid to ask questions. Some of here have been in very long relationships and have been apart from our loved ones many many times.
Here is the Cape May site. Read the company blogs. It will give you an idea what he is doing. http://www.uscg.mil/hq/capemay/Trai...edOnes.asp
Facebook USCG Friends and Family Site.
Company face Book Page
The admins do a great job. If this isn't his company they will get you enrolled to the correct one.
Remember its only eight weeks then you have to face the reality of his next assignment.