Jump to content


Photo

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


  • Please log in to reply
3 replies to this topic

#1 mario60

mario60

    Newbie

  • Members
  • Pip
  • 4 posts
  • Gender:Male

Posted 27 August 2016 - 02:35 PM

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



#2 Sibin A S

Sibin A S

    Advanced Member

  • Admin
  • PipPipPip
  • 105 posts
  • Gender:Male

Posted 29 August 2016 - 02:48 PM

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.weby...electing-tables
 
Regards,
Sibin


#3 mario60

mario60

    Newbie

  • Members
  • Pip
  • 4 posts
  • Gender:Male

Posted 30 August 2016 - 08:27 PM

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



#4 Sibin A S

Sibin A S

    Advanced Member

  • Admin
  • PipPipPip
  • 105 posts
  • Gender:Male

Posted 06 September 2016 - 01:44 PM

Hi,

 

You may refer our doc for more information, here >> http://sqlyogkb.weby...electing-tables and http://sqlyogkb.weby...om-command-line

 

Regards,

Sibin






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users