I can’t quite sail to Bovington, but I can sail to Wareham nearby. Wareham is upriver from the west end of Poole Harbour, and the journey from the Solent to Poole is well known.
The plan would be to catch the morning ebb tide from Fareham at 06:45, sail through the Solent, across Christchurch Bay, into Poole Harbour, and up to Wareham. There are lots of possible stops and sights along the way — Cowes, Newtown Creek, Yarmouth, Beaulieu, Lymington, Mudeford, Christchurch. If things go really well I might sail further to remarkable Lulworth Cove.
PassageWeather predicts fairly light south and south-easterlies, so it ought to be very pleasant. The prevailing winds are westerly, which would make it an uphill slog. I’ll need to look at the weather systems and make my own prediction too.
But it could be a very nice long weekend trip!