>>>From what I've read... SQL Server 7.0 does replication, and VFP makes a nice Front-end to that.
>>
>>Does anyone know of any sort of replication tool, bunch of classes, or whatever that doesn't involve client-server? We're always saying here that vfp can do the job without the big client backend. If no-one has made something, perhaps there is a book that discusses replication topologies and stuff, and helps us handcraft our own?
>
>FoxAudit creates transaction logs. Replication is usually impimented by synchronizing transaction logs.


I was just discussing this subject with Jim Duffy about using FoxAudit for replication. From what I gathered, I think FoxAudit would work great for data replication. The remote site would run your VFP app. w/FoxAudit logging the transactions. When you decided to replicate you grab just the transactions that have occurred since the last update and send them to the other site. The other site takes this information and "Rolls Forward" the transactions.

In the next couple of months I'm going to be trying this out, so I'll see how it goes.

-Paul