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

SJA – Data Sync Based on Date Time Field

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › SJA – Data Sync Based on Date Time Field

Tagged: , ,

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 16, 2020 at 1:41 pm #36502
      nomaam
      Participant

      I have two databases in different physical locations, each table has a date time column.

      I want to sync the tables so they have the same data, but when updating each other, the row with the most current date time field should overwrite the older row.

      This would be a two way data sync.

      I know there is a “where” clause you can add in the SJA wizard, but I don’t know how to write the condition, as I need it to work both ways. Like:

      WHERE DB1.table1.dateTimeField > DB2.table1.dateTimeField then update DB2 with DB1 value, as DB2 is the newest data

      but also go the other way,

      WHERE DB2.table1.dateTimeField > DB1.table1.dateTimeField then update DB1 with DB2 value

      Suggestions?

      Thanks

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