Automatically Synchronizing Data in Two SQL Server Databases

This tutorial explains how to automatically synchronize data into 2 SQL Server databases. Data in SQL databases often needs to be synchronized in real-time — this can be achieved by checking one database for updates and then applying them to another database.

https://dzone.com/articles/automatically-synchronizing-data-in-two-sql-server