HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Distributed database implementation in sql server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqldatabasedistributedserverimplementation

Problem

Currently, We have central Database at Head Office and users from sub offices ,scattered around the country, connect to central database. Now we want to distribute the database in disconnected mode at each Sub office level and we want data to be synchronized at the day end at the central Database from all others Databases. We also want transfer of data to all Databases from central Database. Please refer me the tutorial or way to implement this scenario in SQL Server. Thanks in Advance.

Solution

This is pretty much a textbook example for Merge Replication. Here is the Product documentation describing the scenario, and how to implement it.

Context

StackExchange Database Administrators Q#140810, answer score: 2

Revisions (0)

No revisions yet.