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
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
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
"Ashley T. Howes" wrote:
(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.
Hi all, maybe I'm missing the point but isn't this exactly what XML is for? Regards, Dermot
On Thu, 12 Jul, 2001 at 23:07 +0100, Dermot Musgrove wrote:
maybe I'm missing the point but isn't this exactly what XML is for?
Not really. If you're exchanging data between two systems that you are responsible for, and you know what the data is, there's little need to use XML. For this purpose, a CSV file would be more than adequate and probably about as efficient as you could get. (Whereas an XML file would be overly verbose, and you should probably put together a DTD or XSchema for it.) If you were exporting data and you didn't know who was going to use it, then you might consider XML. Andrew. -- All views are my own, who else would want them?
participants (5)
-
Andrew Savory -
Ashley T. Howes -
Dermot Musgrove -
markj＠cloaked.freeserve.co.uk -
oms101＠freeuk.com