This could be done, but given the potential complexity involved depending on your database system and whether you have other users accessing your data, this may be very simple or extremely complex to do.
Will you be only creating new records or modifying existing records?
Will other users be adding/editing records at the same time you are working off line?
Thank you for your reply. Only the server side administrator will be editing the records. One client side, the user can only use the offline database for ready only purpose. If athe administrator on the server update or add records, can the client side detect it and update the records when internet is available? Many thanks.
The fact that the downloaded database is read-only greatly simplifies the "synch" issue as the data only flows one way.
Identifying records that are new or newly modified would be fairly straight forward. You can add a modification timestamp field to all tables defined in the database where edits might take place. You can use relationships based on this date field or peform finds against the server tables to locate any new and modified records. If any are found, a scripted import records step can import with a matching records setup that updates existing records and adds new records.
The automatic checking process might be a bit problematic. What I'm not sure about is how successfully we can get a a script to attempt connection to a server that may or may not be accessible at the time an On Timer script performs it.