title: How to share (use) data between two databases?
body: <p>We have a "master" application in our organization with a "master" database that contains the majority of the information that our organization depends on.</p>
  
  <p>Then we have another "side" application that has its own database schema, but requires the data that is stored in the master database for operation.</p>
  
  <p>At the moment, every night we run a job that brings in the data from the master database to the "side" database.</p>
  
  <p>Needless to say, this has resulted in lots of headache and has degraded our productivity substantially.</p>
  
  <p>I have made some research and it looks like that using heterogenous data replication it is possible to share the data between the two database in a real-time fashion, but I am not an expert in this area.</p>
  
  <p>So my question is what are some of the best practices for sharing data between two heterogenous databases (in our case, the DBs are SQL Server 2008).</p>