Forum Discussion
Synchronize SQL database between two servers
Questions (to make right the synchronize SQL database between two servers) 1. Is required to have SQL Enterprise in both servers, for to be able the synchronization? Or will be enough to have SQ...
Thank you.
yes, both servers need to be writable.
A topology where multiple replicas are writeable is not something I have experience with.
What you need in the SQL Server world, appears to be "Peer to Peer Transactional Replication".
Peer-to-Peer Transactional Replication - SQL Server | Microsoft Learn (Drawings designed for Light theme)
This will require all participating servers to have an enterprise license.