FoxPro Database Replication

[jwalz]

I am looking for a way to replicate or mirror data fro a FoxPro application. I have other database applications that I would like to have access to a copy this data, with the information being as close to live as possible. I don't want any of my other database applications to access this information directly because of its importance. Plus it is a read-only situation. Any suggestions?

Thanks,
Janet

 

[Mike Gagnon]

Gendbc.prg in the tools directory, will create a program that will recreste the STRUCTURE of the database, and the tables in it and the indexes. But only the structure. The rest would be simple programming to insert the data in the appopriate tables.

 

[DSummZZZ]

Here's a simplified version of what I have done in the past.
Create a logical field on your live data named 'mirror'. Using a separate mirroring app, periodically scan the table and check for the mirror flag and if it is .F., update the offline table. Upon successful update of the offline table, set the mirror flag to .T.

Dave S.