Re: Copying data between databases

In article <01bd743a$11681180$95000006@davidr.bradford.gov.uk>#1/1, "David Robertson" <david.robertson@bradford.gov.uk> 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 > Another alternative is to use PLATINUM Desktop DBA's data export/import feature. Desktop DBA is a Windows-based, multi-server tool for database administration and migration on Oracle, Sybase, Microsoft SQL Server, Informix, and DB2 Common Server databases. Database objects can be created and altered, including tables, indexes, and keys, without knowing the complex SQL code involved. Tedious, repetitive tasks are made simple. Now, Desktop DBA is included in the suite PLATINUM DBA Advantage. For more information on Desktop DBA, including articles and a free 30-day trial download, please visit the product page at: http://www.platinum.com/products/dba/desdbaps.htm Janis Thomas Platinum Technology, Inc. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading