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

Column Changes

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Column Changes

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 19, 2004 at 1:33 pm #16095
      Shadow
      Member

      1. Sja updates ALL monitored columns if a change is detected in any of them. Simply check out the binary logs to see what it does to the data.

      2. We used to run updates to 15 remote offices every day over 128Kbit leased lines with sja and it worked fine for us (we switched to Oracle). However, none of the updates ever exceeded 2MBytes.

    • July 20, 2004 at 11:12 am #16096
      mcolwill
      Member

      Hi

      I seem to have this working but i have a problem with the source being too agressive, in 2 way synch. mode, in fact in either mode

      -if i make a chnage to record 1 in target and not in record 1 in source, the source always overwrites record 1, ie changes never make it from target to source and worse than that, source resets the change in target if target makes one.

      So it seems the changed record is correctly identified but that source always writes over target regardless of who changed it.

      -even in one way synch, target cahnes record, source does not, at end of it i always end up with source record

      Is thsi correct?

      btw, I have only 1 index being primary key on the recordid (in this case personid).

      thanks for your help once again.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.