none
Sync Sql Server and Sql CE with Filter Scope RRS feed

  • Question

  • Hi 

    I had developed a win app in C#(VS 2005) for synchronizing SQL Server 2005 and SQL CE 3.5, the issue is it will sync the entire table but what i want is let the user select particular parameter say country='India' and the data related to this country should synced. 

    Can any one please help me to solve this issue..

    Wednesday, October 6, 2010 10:41 AM

All replies

  • which provider are you using? if its the collaboration providers SqlSyncProvider and SqlCeSyncProvider, it doesnt support dynamically passing the filter value. the filter value is defined as part of the scope.

    you'll have better luck doing this using the SQLCEClientSyncProvider and DBServerSyncProviders (the one used by the Local Database Cache).

    Wednesday, October 6, 2010 2:12 PM
    Moderator
  • Using collaboration providers SqlSyncProvider and SqlCeSyncProvider, you could define separate scope for each filter and this would only sync specific data. What's your scenario? Is dynamic filtering one of the requirements?

    Thanks,

     


    Ann Tang
    Thursday, October 7, 2010 7:26 PM