Re: Communication between databases

Richard Woods <rawoods@concentric.net> wrote: :John J. Kerwin wrote: :> :> What would be a good way to have multiple databases talk to each :> other? :> For example Informix and Oracle. So all data would be the :> same in both databases. :> Right now i am just unloading the data and importing it. :> This doesn't work very well for real time data :) :> :> Could someone recomend a book or software that allows :> databases to talk to each other ? :> :> jkOracle has a family of products called Transparent Gateways that extend, :in many cases, both query and update capabilities to non-Oracle :datastores via ordinary SQL statements. For more information, call :Oracle Client Relations at 415-506-1500. Informix also has this kind of tool and ODBC and other soulutions may do some of the same. What you seem to want however is a full replication between heterogenous databases. May be someting like OmniReplicator from Praxis International might be interesting. I know nothing about the quality of real functionality of their products, but may be you can use it. You amy check out http://www.praxisint.com Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company