Unsupported Screen Size: The viewport size is too small for the theme to render properly.

change in sorce-DB during sync

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › change in sorce-DB during sync

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 20, 2005 at 3:47 pm #8990
      peterlaursen
      Participant

      Thsi is just a question just to “enhance” my understanding of the SJA.

      In case you sync with a production-DB as the source-DB and in case it is a “big” job and in case connection is rather slow, there is a good chance that the source will change during the sync process. How does SJA handle this ? Is it predictable at all ?

    • May 23, 2005 at 4:26 am #17860
      Ritesh
      Member
      Quote:
      there is a good chance that the source will change during the sync proces

      I am not sure if I understood the problem. Can you explain a bit more?

    • May 23, 2005 at 4:42 am #17861
      peterlaursen
      Participant

      example:

      I'm running a one-way sync from a-base to b-base. The sync lasts for ½ an hour.

      Ten minutes aftes the sync has started (and while it's still in proces) some data are UPDATED (or DELETED or INSERTED) in a-base.

      Then the Q is then: what will happen (of these three posibilities):

      1) SJA will CERTAINLY write this change to b-base

      2) SJA will NOT (ever) write this change to b-case

      3) SJA will MAYBE write this change to b-base depending on circumstances.

      possibility 3) is what I call “not predictable”.

    • May 23, 2005 at 4:59 am #17862
      Ritesh
      Member

      The answer is:

      Quote:
      SJA will MAYBE write this change to b-base depending on circumstances

      It will update changes for rows that have still not been considered for the sync.

      To get sure-shot result you have to run the sync again.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.