what does the 'dbcopy' utility do exactly? I know dbexport and dbimport very good, I use them all the time, what I am saying is that the database we have is quite big, maybe more than 10 gig, and we don't have that space on the server to dbexport it and then ftp it to another server.
We thought that with using dbschema to get the SQL file of the database, then loop over the file, then we will not need that much space, since we will load the file then deleted right away. I hope I was clear enough. Thanks, Mahdi. -----Original Message----- From: �yvind Gjerstad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:20 AM To: Mahdi Sbeih Subject: Re: Copying Informix Databases across servers Mahdi Sbeih wrote: > 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. The standard way of doing this is using the command 'dbexport' to export it to disk, tape or a combination. Then you can use 'dbimport' to import it. No need for perl for this, really. Be aware that there is a 2GB limit (actually it seems to be a tiny bit less than 2GB) on the tape size, so if your database is big you may find yourself changing tapes quite often. This size limit also applies to disk files. Normally, the unloaded files you get with dbexport are much smaller than the corresponding table due to having no indexes, etc. dbexport is documented in the migration guide: http://www.informix.com/answers/english/docs/gn7382/4372.pdf You may also look at a utility called 'myschema' which you will find in an archive called utils2_ak.gz somewhere on ftp.iiug.org. While you are at it you can also look at 'dbcopy' in the same archive, and the utilities in utils4_ak.gz . Good luck! -- �yvind ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. (mailto:[EMAIL PROTECTED]) This footnote also confirms that this email message has been swept by viruscheckers for the presence of computer viruses. **********************************************************************
