If you want to share data between multiple databases, then replication could be an alternative, and there are four types of replication you should know to be able to choose the best option:
- Snapshot replication
- Transactional replication
- Peer-to-peer replication (a kind of transactional replication)
- Merge replication
In this video I will show you how to setup Merge replication.