Syncing amongst offline DBs
Is there a hidden field for a record stating its last modified time/date?
We work with field engineers which would benifit from full machine history (and customer data) but are never online 24/7. So local DBs are 'it'
Most syncing would be additional records, but the random updated record would happen.
Exporting a excel or csv, etc file of new/up dated that the others can then import is my game-plan.
Am I going to have to add a timestamp field to each table showing its last modified time?