Re: Q: easiest way to synchonize 2 large databases weekly (even daily)

src@conterra.com (SRC) wrote: >Warning: Gross ignorance demonstrated below: > We have two large databases (~40 million rows +)that we would like to >synchronize more often. Presently every few weeks we take a backup from one >machine and restore it to the other. Two days or more later we have our >(almost) synchronized databases. > How would you do it? > Any suggestions welcomed (include "RTFM!") How about using Informix data replication. You did not mention what release you were on, but if it is 6.x and up, DR comes as part of the engine and seems to be suitable for what you want to do. -- Melvin Mariney, Informix DBA e-mail: melvin.mariney2@bridge.bellsouth.com