Sync Services using ADO.NET --- Need more explanation

All replies

• 

  

  0

  Sign in to vote

  Hi
  
  Indeed, what you want to do seems possible with the MSF v2.0.
  You can configure the MSF to either do a Upload or a Download syncronization.
  
  1. It is also possible to use SQL Server (Standard or Express) as the local database.
      Use the SqlSyncProvider if you are using the Collaboration Providers
      Use the SqlExpressClientSyncProvider if you are using the Offline Providers
      WARNING: this provider is not supported by MS (http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200)
       Also make sure to get the updates from the community (http://www.8bit.rs/blog/index.php/2009/05/debugging-sql-express-client-sync-provider)
  
  2. Yes, this is also possible. The MSF can run inside a Windows Service.
      To use WCF see the following links
      Collaboration Providers: http://msdn.microsoft.com/en-us/library/ee819079.aspx
      updated: new sample available http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762
      Offline Providers: http://msdn.microsoft.com/en-us/library/bb902831(SQL.105).aspx.
  
  HTH,
  Rudi

  • Proposed as answer by Rudi - Euricom Monday, January 18, 2010 8:16 AM

  Tuesday, January 5, 2010 2:14 PM
• 

  

  0

  Sign in to vote

  We have now posted a new SQL Express sample which is based on SqlSyncProvider.
  Please take a look at this sample: Database Sync - SQL Server and SQL Server Express

  ---

  This posting is provided AS IS with no warranties, and confers no rights

  • Marked as answer by Mahesh DudgikarMicrosoft employee Thursday, January 14, 2010 9:54 PM

  Thursday, January 7, 2010 1:16 AM