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

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #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

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