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

How Does Sja Know Which Records Has Been Updated Since Last Run?

forums forums SQLyog SQLyog Comments How Does Sja Know Which Records Has Been Updated Since Last Run?

This topic contains 5 replies, has 0 voices, and was last updated by  Sibin A S 1 year, 2 months ago.

  • Author
    Posts
  • #13558

    mario60
    Member

    Hi

     

    I am curious about how SJA (for Linux) knows which records from a Db/Table has been updated since its last run.

     

    (I understand SJA knows, because if I run it once, updated some rows of the source table, and run SJA again, it dumps just the updated records, doesn’t it?)

     

    If the answer is written somewhere, please let me know where

     

    Thanks

    Cheers

    mario

  • #35767

    Sibin A S
    Moderator

    Hi,

     

    SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

     

    You may refer our doc regarding the checksum calculation for comparing the data between the databases, here >> http://sqlyogkb.webyog.com/article/294-selecting-tables

     

    Regards,

    Sibin

  • #35768

    mario60
    Member

    Hi Sibin

     

    thanks for your reply.

    Do you happen to know a tutorial on how to use checksums to sync two databases?

    Is SJA algorithm documented somewhere?

     

    best wishes

    mario

  • #35769

    Sibin A S
    Moderator

You must be logged in to reply to this topic.