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