locked
what is difference between serversyncprovider and dbsyncprovider class? RRS feed

  • Question

  • I am going to use Ntier architecture(WCF)
    which one should I use or both?


    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:55 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Thursday, October 22, 2009 6:19 AM

Answers

  • Hi,

    It depends on your scenarios. DbServerSyncProvider is for offline scenarios, and it supports device. DbSyncProvider is for collaboration scenarios, It supports SQL Server <-> SQL Server and  SQL Server <-> SQL CE sync. In the latest Sync Framework v2 release, many new features were added for the collaboration providers such as batching supports. Please take a look of the MSDN links for more details: http://msdn.microsoft.com/en-us/library/bb726002(SQL.105).aspx.

    Thanks,
    Dong
    This posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, October 27, 2009 1:39 AM
    Moderator

All replies

  • HI,

    ServerSyncProvider is abstract class thus you cannot use it. In fact, DbSyncProvider is a subtype of ServerSyncProvider.

    You ought to use dbsyncprovider class. If you want to check an example running for devices look at http://synccomm.codeplex.com

    Cheers,

    José Miguel Torres
    Friday, October 23, 2009 1:58 PM
  • Hi,

    It depends on your scenarios. DbServerSyncProvider is for offline scenarios, and it supports device. DbSyncProvider is for collaboration scenarios, It supports SQL Server <-> SQL Server and  SQL Server <-> SQL CE sync. In the latest Sync Framework v2 release, many new features were added for the collaboration providers such as batching supports. Please take a look of the MSDN links for more details: http://msdn.microsoft.com/en-us/library/bb726002(SQL.105).aspx.

    Thanks,
    Dong
    This posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, October 27, 2009 1:39 AM
    Moderator