AnsweredAssumed Answered

CONTROL / IMPORT FROM MULTIPLE DATABASES

Question asked by Saltaras on Feb 8, 2013
Latest reply on Feb 9, 2013 by davidanders

Title

CONTROL / IMPORT FROM MULTIPLE DATABASES

Post

     I have written a database in FP12 that handles medical records from various clinics.  However, to keep the speed up and satisfy certain security requirements, I need to run one database for each clinic. 

     I would like to then have one "master" database which can import and combine the data from all five to be used by central administration.  Changes then made centrally must propagate back to the smaller files and be visible on the clinic databases (and visa vers). All of the databases have identical structure, fields, etc.  so its really just a matter of importing specific fields based on time of change.  I have though of using a script to import records automatically every 30 minutes etc. But am not sure if there is a better way.  Any suggestions?   Is there a script to import only new records and to replace current record if imported record is more recent etc.?

     Thanks.

Outcomes