title: sync SQL CE with SQL Server
body: <p>Hi can anyone suggest how to sync a table in sqlCE with a table in sql server.</p>
  
  <p>I currently have a windows application which uses table X from SQL CE to add new records(a form data) and later when it is connected to network I will need it to update all those newly inserted records to the table Y(equal to table X in CE) in sql server.</p>
  
  <p>The sql CE version is 4.0  and it is not connected to server all the time.The sync needs to be done when it is connected to server on a click event.</p>
  
  <p>The sql server is 2012.</p>
  
  <p>How do I achieve this </p>