Re: Copying data between databases

David Robertson wrote: > > I need to copy a high volume of data from one database to another on a > regular basis. > > I currently use two SQL scripts - the first to unload the data from the > first database to a flat file, the second to reload into the second > database. I would like to speed the process up by doing away with the > intermediate file. I have tried using a "named pipe" ( fifo ) as the > file, and running both the unload and reload processes concurrently. This > has yeilded some improvement, but not as much as I believe is possible, as > it still appears to write and read from disk during the copy. > > If anyone knows a way of using Informix SQL or 4GL to facilitate a fast > transfer I will be grateful for some indication of how to do it. How about an ESQL-C solution? Download my latest submission to the IIUG Software repository (utils2_ak) it includes docopy.ec a very fast table copy program. BW Have you tried: INSERT INTO localtable SELECT FROM remotedb:remotetable; As long as the two databases have compatible logging modes this will work. Docopy is as fast and if the databases have incompatible logging modes something like it is the only solution. Art S. Kagel