Best practice bring MS SQL database to remote sites
This is exactly what replication is designed for.  Sounds like Transactional replication with updateable subscriptions will work although MS is saying this will be removed down the road (no specifics)

Merge replication is also a choice, but is more complex to maintain.