title: Communication between local database and centralized database
body: <p>I have to develop a C# .net windows application for a client.The             database is SQL Server.Our client has 18 offices in various countries.This desktop application will be instlled in all offices.There will be local database in all 18 offices and also there will be centralized database.</p>
  
  <p>My questions are given below.</p>
  
  <p>1) How can we move data from branch server to central server and also from central server to branch server?</p>
  
  <p>2)How faster and constant connection to database server is achived?
    Also how can we achieve real time updates between all branches and central server?</p>
  
  <p>3)How MSSQL can sync with multiple servers in realtime over the      internet?</p>
  
  <p>4) Can we achieve these things in a place where there is no internet connection?</p>