locked
Will filtering remove unnecessary items? RRS feed

  • Question

  • The Books Online describe how filtering can be used to limit the data synchronised with the client database. My question, without having installed the SDK and sample :-( , is what happens if the parameter to the filter is changed? Are records that are no longer to be synchronised removed from the client database? And if they were, what would happen to any changes already made to those items on the client?

    Taking the example from the Books Online, what would happen if a different sales person logged on to the laptop? Would both sets of customer details now reside on the laptop? Doubling the client database size and exposing more data in the event of the laptop being stolen.

    Whilst different sales people logging on to a laptop may be a rarity, the filtering might be by some other criteria designed to reduce the important information left vulnerable on the laptop. For example, you may only wish to synchronise full details for customers you are due to visit within the next seven days, and only synchronise basic "stub" details for all your other customers. This scenario requires some cleanup of the superfluous data.

    • Moved by Max Wang_1983 Friday, April 22, 2011 9:52 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, November 6, 2007 11:19 AM

Answers

  • Hi Piers,

     

    - When the filter changes, the data is not realigned automatically. The new filter will be used in the next sync to pick those records the meet the new filter. Changes on the client will be uploaded regardless of the filter though.

     

    - One way to implement the scenario for different sales person is to have two different databases. One for each sales person. Remember, that CE database is very light weight and the database is just a small file.

     

    - CE database can be encrypted to protect against stolen laptops.

     

    Thanks

    Friday, November 9, 2007 11:38 PM

All replies

  • Hi Piers,

     

    - When the filter changes, the data is not realigned automatically. The new filter will be used in the next sync to pick those records the meet the new filter. Changes on the client will be uploaded regardless of the filter though.

     

    - One way to implement the scenario for different sales person is to have two different databases. One for each sales person. Remember, that CE database is very light weight and the database is just a small file.

     

    - CE database can be encrypted to protect against stolen laptops.

     

    Thanks

    Friday, November 9, 2007 11:38 PM
  • Thanks Rafik for the clarification

     

    A second database doesn't help when the filtering is based on some other criteria, e.g. sales leads that are over 6 months old or orders that have been fulfilled etc. etc.

     

    I guess the answer to my question is, no. So the application will need to perform any cleanup of unwanted information itself. That is OK so long as the developer knows that is so.

    Saturday, November 10, 2007 3:45 AM