migration DB without stop ids server or else

Posted in 2003

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues

roger huang — 28 Nov 2003 02:20:16 -0800 — source: Usenet: comp.databases.informix

hi, I like to migrate HP ids7.3 to AIX ids9.4. I hope that I can migrate to AIX without stopping HP server, or just for a few hours. I have about 100 GB data, and I thinks that It is impossible to migrate in a few hours, even use Art S. Kagel's dbcopy. Is anyone can give me some good advice ?

↪ replying to roger huang

Art S. Kagel — Fri, 28 Nov 2003 11:05:44 -0500 — source: Usenet: comp.databases.informix

On Fri, 28 Nov 2003 05:20:16 -0500, roger huang wrote: > hi, > I like to migrate HP ids7.3 to AIX ids9.4. > I hope that I can migrate to AIX without stopping HP server, or just for a few > hours. I have about 100 GB data, and I thinks that It is impossible to > migrate in a few hours, even use Art S. Kagel's dbcopy. Is anyone can give me > some good advice ? For that much data, I'd use the HPLoader. Unless the data is split into MANY relatively small tables, dbcopy cannot keep up with hploader. If many many tables, then the overhead of hploader and the ease of creating scripts to dbcopy many tables at once and to copy a larger table with multiple copies of dbcopy, can make dbcopy a preferred choice. For raw speed though hploader is superior. Art S. Kagel

Glossary

IDS (Informix Dynamic Server)