• Heavybell@lemmy.world
    link
    fedilink
    arrow-up
    7
    ·
    1 year ago

    MS SQL Server has this thing called Replication. It’s a feature to keep tables in sync between databases, and even database servers. There’s merge replication (two way), snapshot replication (one way scheduled publishing), and transaction replication (one way live-ish publishing).

    And the logic is all implemented in T-SQL stored procedures.

    I fucking hate it.