title: Continuously synchronize tables between two databases
body: <p>I have had my experience with MSSQL Server somewhat 6 years ago, so I have only basic knowledge of its workings now.</p>
  
  <p>The problem I'm posed with is that of syncing the databases between two live CRMs (NopCommerce and Rainbow Portal-based one if anyone's curious) running on the same DB server. The data I'm interested in is spread out among 7 tables in one DB and 5 in the other one. The idea is to have two web applications with same data with updates in one instantly propagating to the other.</p>
  
  <p>Each database has numerous triggers and stored procedures that are used to keep the data consistent.</p>
  
  <p>I am not aware of all possibilities of SQL Server, so I am open to suggestions as to what is the best and quickest way to achieve the goal. Is it about writing more triggers? Should I create a "watcher" application? Is there some built-in mechanism for that?</p>
  
  <p>Thanks!</p>