On 11-Jul-01 markj@cloaked.freeserve.co.uk wrote:
On 10 Jul, Ashley T. Howes wrote:
The two databases could be synched with a lot of human work, but is there a method to do this automatically - perhaps sending XML between the two? Anyone got experience in doing this sort of stuff?
MzScheme with SchemeQl, Perl with DBI, Ruby with DBI... there's probably as many ways to do this as there are programming languages. Just open connections to both databases and query one while you update the other.
There's probably some automated database sync tools out there, but whether they're flexible enough for you...
MJR
I thought the most common way to do this was to run the transaction log through the data base you want to replicate to.
Interbase (Open Source RDBMS) version 6 now supports replication wjhile Interbase 5 did not. I looked into replication and I think its painfull if you do it by hand though others on this group have done it I should not advise it if you can avoid it.
Owen Synge
Date: 11-Jul-01 Time: 15:45:49