Re: Best practice: Copying databases

You can use my dbexport/dbimport replacement utility package, myexport. It can optionally use the HPLOADER to unload and reload the table data much faster than dbexport and dbimport can. Myexport can also export the database in parallel unloading all tables at once which can speed the process. Myexport is downloadable from the Oninit web site ( www.oninit.com/utils) or the IIUG Software Repository (www.iiug.org/software). Myexport also requires my dbschema replacement tool (for schema support) from the utils2_ak package (same sources), Jonathan Leffler's sqlcmd package and Ravi Krishna's myonpload package (both at: www.iiug.org/software) Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, May 25, 2009 at 3:29 PM, Scott Newton < scott.newton@integralgroup.co.nz> wrote: > Traditionally we have always done this using dbexport/dbimport but with all > the new flash tools in the later versions of IBM Informix I was wondering > if > there are better ways of doing this these days. What do other people use? I > suppose the question comes down to: Do IBM Informix have any best practice > guidelines? > > Thanks > > -- > Regards > > Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd > 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Shore City > 0751 > DDI 09 302 3788 | Fax 09 477 0478 | www.integralgroup.co.nz > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >