title: MySQL or Microsoft Sync Framework Synchronization / Replication
body: <p>I am creating an application that has one server and multiple clients.  It is a c# app that uses ADO.NET Entity Framework 4 over a MySQL database.</p>
  
  <p>The clients need to get data from several database tables on the server. There are also 2 separate tables that need to be sent from the clients to the server.  At some point, the client should be able to delete some of the old data in these 2 tables and have it stay on the server.  The clients need to be able to work if they get disconnected from the server for some time and tables need to be updated at some point after reconnection.</p>
  
  <p>I was thinking about going with MySQL replication but I don't think the client would be able to delete old data without effecting the server tables.  I have looked at Microsoft sync framework as well, but I am not sure if that is ideal or would even work for my needs.  </p>
  
  <p>I don't know a lot about this subject so some direction would be appreciated.  </p>
  
  <p>Thank you,
  Matt W</p>