title: Difference between Transactional and Reporting Database
body: <p>A friend commented like this: </p>
  
  <blockquote>
    <p>I'd recommend separating out your <strong>transactional data</strong> and your <strong>reporting data</strong> into a separate database</p>
  </blockquote>
  
  <p>And another one told me:</p>
  
  <blockquote>
    <p>I would implement an E-R schema in the <strong>transactional data</strong> and a star schema for the <strong>reporting database</strong></p>
  </blockquote>
  
  <p>Can anyone make both clear for me? I ask, because I really didn't get difference?</p>