Using Sync WCF On SQL Express on both Client & Server !

All replies

• 

  

  0

  Sign in to vote

  Doesn't anyone have a solution ? :(
  

  ---

  Don't be afraid people, my business is only about 1 or 0.

  Saturday, December 18, 2010 8:37 AM
• 

  

  0

  Sign in to vote

  You can check out the document at http://msdn.microsoft.com/en-us/library/gg299051(v=SQL.110).aspx and see whether Sync Framework 4.0 CTP meet your requirements? There are also other information mentioned at http://blogs.msdn.com/b/sync/archive/2010/10/28/announcing-sync-framework-4-0-october-2010-ctp.aspx as well (such as a pdc video)

  • Marked as answer by jigu2014Microsoft employee, Editor Monday, December 20, 2010 6:36 PM
  • Unmarked as answer by modRami Wednesday, December 22, 2010 10:40 AM

  Monday, December 20, 2010 6:33 PM

  Answerer
• 

  

  0

  Sign in to vote

  The problem is that I don't want to consume this service using Silverlight... and what I want to do instead of having the data as collections, nor use SQL Compact, I want to Push data online from a local SQL Express Database to an online SQL Server or SQL Express using sync so that I don't push all the data, any solution ? And at the same time, I want the online database to be exposed as OData using WCF service.

  ---

  Don't be afraid people, my business is only about 1 or 0.

  Wednesday, December 22, 2010 10:33 AM
• 

  

  0

  Sign in to vote

  The sync framework 4.0 not only support device/silverlight client but also desktop clients. It exposes Server data as OData format, the client can be a local application with SQL Express.

  Also, if you just want to sync SQL Express with online SQL Server/SQL expression, you can take a look at the sample at http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762 and see whether that will help. Though it does not expose the service in OData format.

   

  • Proposed as answer by jigu2014Microsoft employee, Editor Wednesday, December 29, 2010 7:51 PM
  • Marked as answer by jigu2014Microsoft employee, Editor Friday, December 31, 2010 7:44 PM

  Wednesday, December 22, 2010 6:06 PM

  Answerer