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.
if you need use sql server for distributed plan, I know about 2 scenario:
you can use Big Data Clusters for store big data in HDFS managed by SQL Server, read about in reference this scenario :
Use Service Broker for Asynchronies 2 or more SQL Server in distribute plans. you can read about in below link:
Developers can easily create sophisticated applications that use the Database Engine components to communicate between disparate databases, and build distributed and reliable applications.
In other scenario you can use Always ON, Replication , Mirror . but i guess you need use Service Broker.