title: Which one is the best method to replicate a database in SQL Server?
body: <p>I was wondering which one is the best way to replicate some data of a database to another.</p>
  
  <p>I have a database in one computer and this one receives some transactions. I need to send this data to another server (in the same local network) but with a modified value (I need to add 11 years to a Timestamp value).</p>
  
  <p>So I was looking for some options for my case, I can develop a windows service to do this but I don't know if the sql server replication can do this for me or if there is another option like some kind of magical trigger that can do that.</p>
  
  <p>I'm using SQL Server 2005 on Windows Server 2003 R2.</p>