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

2 way SJA does not update on target SQL server

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › 2 way SJA does not update on target SQL server

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 21, 2005 at 4:44 pm #16748
      pektop
      Member

      have same problem. two way sync workin as a one way. Any help please?

    • January 22, 2005 at 1:33 am #16749
      peterlaursen
      Participant

      If the value of the Primary Key is identical for some rows in the two databases, SJA will ALLWAYS overwrite the target with data from the source. That's how it's supposed to work! Are you sure that's not the problem ?

      SJA identifies the rows by PK and nothing else. It's been requested from time to time by users that there should be other options, and Ritesh has (a I remember) written here that they will look into that, but I'm not sure if there is any conclusion yet.

      However I believe, that it should be possible to use any unique index. A timestamp could be part of such a unique (composite) index. Problem with timestamps however is that the format has changed from different Mysqlversions. So if not the server versions are identical, results could be unpredictable.

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