High Performance Loader and DB cloning
Posted in 1998
Greg Moye — — source: Informix-list mailing list archive (1991-1998)
Has anybody managed to clone a large (i.e. lots of tables and lots of data) database with the HPL? It looks very table by table oriented to me after a scan through the manual. I occasionally need to clone an 8000+ table database, the faster the better. Obviously unloading/loading table by table isn't going to get it for me. Optimally I'd like to do something like "unload this entire database to that bunch of disks" with it's schema then "load everything on that bunch of disks to this other database, and apply schema to yield a perfect clone" Am I dreaming?? Thanks - Greg