Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › SJA – Data Sync Based on Date Time Field
Tagged: database sync, SJA, sqlyog
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