>>>>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

It seems you're talking about uni-directional replication. Do you have an information about FoxAudit and bi-directional replication?

Years ago I used a product called DB-Log that did just what you said FoxAudit does, log transactions that could be used for replication. I found it very combersome to do bidirectional replication with more than 2 sites over non-dedicated communications link (e.g. dial-up). I had to abandon the use after couple of months of hard labor.