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. > > David Robertson > (please remove anti-spam when replying) > david dot robertson at bradford dot gov dot uk Doesn't the new 7.3 replication feature do this? It uses log snooping so is quite cheap on the read side. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/