none
How to prevent from synchronizing the bad data through Microsoft Syn framework? RRS feed

  • Question

  • I just thought about this question recently. We have a server and 50 clients. The 51 database instances should be synchronized.

    However, the client servers will be installed on laptops that uses can take them to everywhere. If one laptop messes up with its database, the mess will spread to all other databases.

    I think about to use Row filter. The client can only upload the data that entered by this client. If the client makes change with a data that was entered by other laptops or server, this change will not get synchronized.

    I am not sure if this can work. I also open to other solutions.

    Thanks!


    Friday, August 19, 2011 1:36 PM

Answers

  • either by filtering or intercepting the changes at ChangesSelected event.
    • Marked as answer by jz2012 Monday, August 22, 2011 10:35 AM
    Saturday, August 20, 2011 12:29 PM
    Moderator

All replies

  • if a client is not supposed to be modifying somebody else's data, you can either not allow them to download it in the first place. if they need to see that data but not edit, then your application should include the logic to prevent another client from modifying somebody else's data. it doesnt make sense to allow them to update it and not allow them to submit and upload the data anyway. as a last defense, yes, you can configure Sync framework to prevent the upload of changes to data that doesnt belong to the client.

    Friday, August 19, 2011 2:04 PM
    Moderator
  • Thanks for your response!

    What I worried about is that malicious users may access database directly and manipulate the data, then the bad data will spread around other databases. Thus, putting the logic into application to prevent from updating others data may not work in this case.

    When you mentioned “you can configure Sync framework to prevent the upload of changes to data that doesn’t belong to the client”.  Do you mean the “Row Filter” or other techniques?

    Please advise!

    Friday, August 19, 2011 7:15 PM
  • either by filtering or intercepting the changes at ChangesSelected event.
    • Marked as answer by jz2012 Monday, August 22, 2011 10:35 AM
    Saturday, August 20, 2011 12:29 PM
    Moderator