If your database is truly huge you would be much better off if you figured out a way to use an Informix backup and restore. I've tried to copy a database, much smaller than huge, only of about 65 gig across our LAN to no avail. I've also written perl code that will with varying levels of success copy databases using similar methods to what you've described and attempted to even use the High Performance Loader triggered from perl. Using the HPL has been temperamental at best, but I've successfully moved a few databases using the schema copy / data copy script. However, the caveat it that it takes quite some time to copy the entire database.
HTH, -Darryl -----Original Message----- From: Mahdi Sbeih [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 6:36 PM To: [EMAIL PROTECTED] Subject: Copying Informix Databases across servers Hi all, I am not sure if I will find answer here, but I am going to try anyways. We want to copy a huge database from one informix server to another one, both server are on the same LAN newtork. What we are thinking to do is, writing a perl script that uses DBI and DBD::Informix, this script will get the schema using dbschema tool, then loop throguh the schema ceating one table at a time and then unload the data for that table in a file then load to the new database on the other server, finally we delete the unloaded file. Is the any other way to do so, I mean something like module that is added to DBI or somthing like this. Regards, Mahdi. ____________________________________________________________________________ The information contained in this communication may be confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message and any copy of it from your computer system. Thank you. For more information about Piper Marbury Rudnick & Wolfe, please visit us at http://www.piperrudnick.com ____________________________________________________________________________
