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.


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.