title: Reliable alternative to replication for continous data sync between two databases
body: <p>I have one central database and 25 client databases and all have same schema. </p>
  
  <p>I want that whenever some changes are done in some tables of the central database then these changes flow down to the client database.</p>
  
  <p>The databases  used is SQL Express so I cannot use replication.
  The solution that I have today is to make keep track of the changes in the central database and then a program makes a text file with these changes and sends them down to the client databases.Another program reads these text files and updates the client database.</p>
  
  <p>There are three problems with this:-<br>
  1. The files get lost or arrive in jumbled order which messes up the client data<br>
  2. the process is slow
  3. the programs are sometimes shutdown so the whole sync flow gets stopped.</p>
  
  <p>Is there a reliable alternative that is fast and secure ?
  I wonder how banking software are made ...they never lose transactions and they are fast.</p>