title: Can I sync mobile, desktop and web server databases with Sync Framework?
body: <p>I'm using Sync Framework v1 (which includes Sync Services for ADO.NET v2) and Sync Services for mobile v1.</p>
  
  <p>I can sync a SQL Compact Edition database from a mobile device to SQL Express on a desktop PC. </p>
  
  <p>I can also sync a SQL CE database from a desktop PC to a SQL Server database on a web server using WCF.</p>
  
  <p>I want to sync from the mobile device to the desktop when it docks, and then have the desktop PC sync with the web server (the copy on the desktop machine is in case the web connection is unreliable). </p>
  
  <p>Ideally, I'd like to avoid SQL Express anyway because I want the mobile &amp; desktop setups to be as simple as possible.</p>
  
  <p>Unfortunately, it looks like there's no way to fit these pieces together to make the connections I need because:</p>
  
  <ol>
  <li>The mobile device syncs to SQL Express on the PC, and I can't sync from SQL Express to SQL server.</li>
  <li>Syncing to SQL server has to come from SQL CE, and I can't sync the mobile device to SQL CE on the desktop</li>
  </ol>
  
  <p>Is this just not possible, or possible with a large amount of code (custom SyncProviders and hand-crafted update statements etc), or have I missed something obvious?</p>
  
  <p>Thanks for your time!
  Mark.</p>