You are here:
- Home
- Computing/Technology
- Databases
- Ingres
- Ingres to Flat File
Ingres/Ingres to Flat File
Advertisement
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
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 ?
Hope this help,
Regards,
Jean-Pierre ZUATE
http://lafageconseil.fr
Related Articles
Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - Ingres 9.x, Ingres 10.x - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...
Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert
- Data modelisation
- ETL
- Reporting
- Many of Computer Associates sofwares
- ITIL / CMDB / Change Management
Organizations
http://lafageconseil.fr
Education/Credentials
Computing bachelor (1989)
Past/Present Clients
More than 100 customers during my 6 years of CA has an Ingres consultant, all around France and Africa (Togo, Cameroon, Morrocco, ...)
©2012 About.com, a part of The New York Times Company. All rights reserved.