title: One way replication for demo site using MS SQL
body: <p>I've been tasked with providing data from our live server to a demo site, so that our sales team can demonstrate the system with the most up to date data available, but not show their changes on our live site.</p>
  
  <p>The data on live does not change often during the day after an initial load of additional data,  but I am worried about conflicts if a data row on demo is changed in a table that is subsequently changed on live and replicated.</p>
  
  <p>Looking at merge replication, a fresh database could be provided, say once per day, but the length of time to replicate could be excessive and, as sometimes our main data feeds to our live data is late, we would need to re-run the merge.</p>
  
  <p>Looking at transactional with updatable subscription, conflicts may occur (also, I do believe that Microsoft are reserving the right to drop this method)</p>
  
  <p>My question is, is there a form of merge replication, that only updates changes, rather than updating the whole database, but allows the subscriber to be used and changed as required?</p>