title: How can I minimize the data in a SQL replication
body: <p>I want to replicate data from a boat offshore to an onshore site. The connection is sometimes via a satellite link and can be slow and have a high latency. </p>
  
  <p>Latency in our application is important, the people on-shore should have the data as soon as possible. </p>
  
  <p>There is one table being replicated, consisting of an id, datetime and some binary data that may vary in length, usually &lt; 50 bytes. </p>
  
  <p>An application off-shore pushes data (hardware measurements) into the table constantly and we want these data on-shore as fast as possible. </p>
  
  <p><strong>Are there any tricks in MS SQL Server 2008 that can help to decrease the bandwith usage and decrease the latency? Initial testing uses a bandwidth of 100 kB/s.</strong></p>
  
  <p>Our alternative is to roll our own data transfer and initial prototyping here uses a bandwidth of 10 kB/s (while transferring the same data in the same timespan). This is without any reliability and integrity checks so this number is artificially low. </p>