title: send the data from 5 local machines to one main server
body: <p>I have 5 databases that have the same structure, each one on a local machine and sixth one on the main server. all these five should send the data from local machines to the main server to one database.</p>
  
  <p>I tried "Replication" but it seems each time i did replication it deleted the data from the main server and copy it again from the local, which keep the main server have just data from one server not all 5 .</p>
  
  <p>so anyone can help me with that??, i'm using SQL server 2008 and all these machines connected with main server over VPN "IPsec"</p>
  
  <p>Thanks.</p>