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

Melvin Mariney wrote: > > 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. > Data replication is the answer. However, before you set up data replication, copying data directly between two databases is easier and faster than backup/restore: using insert/update with select statement, you can write a stored procedure to accomplish that. Just remember to insert the "_database@server_:" in front of the remote table. Chao