title: SQL Server 2014 / Data Sync / Offline application
body: <p>I'm looking for CURRENT advice/information on how to manage an offline client that will sync changes to the cloud. I would love to find an example using SQL Server 2014.</p>
  
  <p>Primarily the client app is a data collection device that will upload the data collected.  AS there will be many devices collecting data I'm anticipating lots of data going up, but only reference data coming down (no point in syncing all the data being collected to all the devices).</p>
  
  <p>I've searched the web and Stackoverflow, and only have found information on the Sync framework dating back to 2010, which sounds really old to me.  My gut is telling me that Sync 2.1 (last release was 8/18/2010 (<a href="http://www.microsoft.com/en-us/download/details.aspx?id=23217" rel="nofollow noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=23217</a>)</p>
  
  <p>I've reviewed these links (as well as many others):</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/sync/bb736753.aspx" rel="nofollow noreferrer">Developer Page</a></p>
  
  <p><a href="http://blogs.msdn.com/b/sync/" rel="nofollow noreferrer">Sync Blog - 3years old</a></p>
  
  <p><a href="https://stackoverflow.com/questions/13738900/microsoft-sync-framework-for-sql-server-and-azure-master-slave">Stackoverflow Question</a></p>
  
  <p>I'm using an Azure SQL Server Standard Edition VM (as I also need SSRS hosted) in the cloud.  Clients are WPF (maybe reach for Win8) applications running on Win8 tables, .Net 4.5, and SQL Server Version 12.0.2000 (not compact).</p>
  
  <p>I built a prototype, and the only "real" problem that I don't fully understand is the Sync framework, as I can only achieve a "sync" with the sync direction of UploadAndDownload. Upload or Download by itself will not work.</p>