none
What's the most efficient way to purge old data in a multiple terminals system with SyncFx 2.1? RRS feed

  • Question

  • For a system with one Master and two slaves terminals that use sync framework for updating each other and each with its own SQL 2008 R2 Express instance, when we need to purge the old data from the database, should we purge the data from the Master terminal and let the sync framework to populate the data deletion or we purge the data from all of the three terminals at the same time? Does either method cause any problems?
    Thursday, May 31, 2012 8:49 PM

Answers

  • each terminal will be recording the delete, and when they sync, they will all send the deletes to the central server and will simply fail on the destination since there is nothing to delete if you already deleted it on the central server.
    • Marked as answer by bli88 Friday, June 1, 2012 1:03 AM
    Friday, June 1, 2012 1:01 AM
    Moderator

All replies

  • purge it from the central server and let the sync cascade the deletes to the clients...

    Thursday, May 31, 2012 11:49 PM
    Moderator
  • What if we do it on all terminals? Will it cause problems? It seems, intuitively, purging from all terminals would save the system time and more efficient. But it sounds like from you that it's the opposite? What's the reason behind it?

    Thanks!

    Friday, June 1, 2012 12:04 AM
  • each terminal will be recording the delete, and when they sync, they will all send the deletes to the central server and will simply fail on the destination since there is nothing to delete if you already deleted it on the central server.
    • Marked as answer by bli88 Friday, June 1, 2012 1:03 AM
    Friday, June 1, 2012 1:01 AM
    Moderator
  • Ok. I see. Thanks a lot JuneT for all of your answers!
    Friday, June 1, 2012 1:03 AM