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.
Sql-server – Distributed database implementation in sql server
distributed-databasessql server
Related Question
- Sql-server – Multi-Datacenter design for SQL Server
- Sql-server – Loop for restoring databases
- Sql-server – Replicating data to a head office with limitations
- Sql-server – Best practice bring MS SQL database to remote sites
- SQL Server – Performance Issue When Querying a Big Table Using PK/Clustered Index
- SQL Server – Distribute Data from Source to Destination Database
- Sql-server – SQL Server CLE Encryption Implementation
- How to model local exceptions to distributed tables
Best Answer
This is pretty much a textbook example for Merge Replication. Here is the Product documentation describing the scenario, and how to implement it.