Database Replication

[Peter Bowen]

The problem:

I've got a >100 000 record database hosted at fmgateway.

Users access the data via cwp.

The user speed is fine.

Other processing with this data happens using fm pro on my desktop with the data at fmgateway (separation model). It's really slow.

If I store the data on my local fmserver the processing speed is fine but then the user cwp access is slow (because I have adsl)

I thought I could have 2 identical databases - one running locally and the other hosted at fmgateway and replicate them.

I looked at a commercial replication solution but it seemed a bit pricey.

Any ideas?

Thanks

Pete

[mr_vodka]

Perhaps you can get some space with them where you can have an installed copy of Pro. It would be the best way of running the process all with the provider.

I dont know much about fmgateway, but I believe that when I last used dbdom, they had virtual boxes that could do these type of functions.