Question Jean, I want to export an Ingres database or tables to an ascii file so I can load the file via sqlloader into an Oracle database. So what do I do with the copy.in and copy.out files after they are generated? Thank you for your time.
-Ian
Answer Hello,
First ensure you use the -c option in copydb to have ASCII data files (vs binary, not usable in other technologies).
Then use the Ingres command : sql
Example : sql yourdabase < copy.out
The copy.in and copy.out contain only SQL instruction to unload (copy.out) and reload (copy.in) your data.
Excuse-me to ask this question : why your customer want to leave Ingres ? Did he think to the TCO of his database ? Performance ? Quietness of administration ?
