Forum Discussion

msalka's avatar
msalka
Copper Contributor
Jan 27, 2026

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...
sql server
ssms
synch
carlwalk's avatar
carlwalk
Brass Contributor
Feb 04, 2026

I guess for live, automatic syncing, SQL Server’s built in options like Availability Groups or transactional replication are usually the cleanest solutions. If you only need scheduled updates, tools like log shipping or even regular backup/restore jobs can work fine. The key is deciding whether both servers need to be writable or if one is just a read only copy. Once you know that, choosing the right method becomes much easier.

msalka's avatar
msalka
Copper Contributor
Feb 04, 2026

Thank you.

yes, both servers need to be writable.

  • SivertSolem's avatar
    SivertSolem
    Iron Contributor
    Feb 06, 2026

    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.