Ashley, what database engine would you be running? I'm guessing it'll be something Opensource, but we did have a project here a couple of years back that replicated three Oracle databases between three different sites round the World.... AFAIK it worked okay, but the bandwidth becomes an issue if there's a lot of traffic and a high frequency of updates.
Andi
"Ashley T. Howes" ashley@blueskyresearch.net on 10/07/2001 19:12:31 To: alug@stu.uea.ac.uk cc: (bcc: Andrew Chandler/PSD/LONDON/FTI)
Subject: [Alug] Sending information between databases
(This isn't a pure linux question, but I hope you can help)
What is a good system for sending information between databases, with minimal human interaction? Situation is that someone has a database in one location, another person has another copy. The list of tables/fields between the 2 databases is not exactly the same, but have several tables in common.
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?
Ashley
_______________________________________________ alug, the Anglian Linux User Group list Send list replies to alug@stu.uea.ac.uk http://www.anglian.lug.org.uk/ http://rabbit.stu.uea.ac.uk/cgi-bin/listinfo/alug See the website for instructions on digest or unsub!
********************************************************************* * Please visit the web site of the Financial Times at: * * http://www.ft.com * * * * For UK personal finance, please visit http://www.ftyourmoney.com * * * * This E-Mail is intended for the use of the addressee only and may * * contain confidential information. If you are not the intended * * recipient, you are hereby notified that any use or dissemination * * of this communication is strictly prohibited. * * If you receive this transmission in error, please notify us * * immediately then delete this E-Mail. * * * * * postmaster@ft.com * *********************************************************************