Re: INFORMIX/INGRES
Posted in 1997
Rob Acraman — — source: Informix-list mailing list archive (1991-1998)
Hi There,
>
> 1. Download the data from Informix-Online to a flat file (ASCII format)
> and transfer (FTP, rcp, etc) it to the other system running INGRES.
>
> My question here is that can INGRES "upload" the data from the
> mentioned flat file to it's own database. In short, does INGRES have
> similar features of "LOAD" and "dbimport".
Yes, Ingres SQL has the 'COPY' command, so you can copy from a file to a
table or vice-versa. You can specify which columns get loaded, what
delimiters are used, etc.
>
> 2. Source for a third-party software that allowed data interchange from
> Informix-Online to INGRES database. Any ideas here ?
Nope
>
> Please advice. Thank you.
You're welcome,
Rob