Re: Using ER for Migration from 10.0 to 11.5

informix-list-bounces@iiug.org wrote on 12/19/2008 09:41:13 AM: > [image removed] > > Using ER for Migration from 10.0 to 11.5 > > Andrew Ford > > to: > > informix-list > > 12/19/2008 09:43 AM > > Sent by: > > informix-list-bounces@iiug.org. > > We are in the process of migrating from one server running IDS 10. > 00.UC5 32 bit Red Hat Linux 3 to another running IDS 11.50.FC3 64 > bit Red Hat Linux 5. > > I would like to us ER to keep the new server in sync with the old > server until we actually migrate. > > I have unloaded the data from the old server and loaded it into the > new server. > > I have defined and started replication from the old server to the > new server for all tables. > > What is the best way to syncronize the new server with the old > server in order to capture the changes that have occurred since the > start of the old server unload and the start of replication? > > I'm more interested in minimizing the impact to the old server > (production) when syncronizing large tables than I am with the speed > of the syncronization. > > Is the 'cdr check replicate' command with the repair option > preferred or is the 'cdr sync replicate' option preferred in this > scenario? To minimize the impact on production system, 'cdr check replicate' with repair (-R) option would be better over 'cdr sync replicate'. cdr sync - would replicate all rows where as cdr check (with repair) - would replicate only inconsistent rows. > > Thanks, > > Andrew > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list