SQL Server Replication

29 Sep 2019 0 minutes to read Contributors

Image result for SQL Server replication

Replication

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Use replication to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

Microsoft Sync Framework

As an alternative to replication, you can synchronize databases by using Microsoft Sync Framework. Sync Framework includes components and an intuitive and flexible API that make it easy to synchronize among SQL Server, SQL Server Express, SQL Server Compact, and SQL Azure databases. 

 

More info here: https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication

In this article