Question I want to Import xml or mdb or sql database into my ingress database ; how i will do that ?
Answer Hello,
As far as I know the simpliest way is to import data via Ingres Import Assistant. You can find this windows only tool in the Ingres menu or by right-clicking on the green cylender on the bottom right corner of the screen.
The following is (at least) true on my own Ingres version : II 9.1.0 (int.w32/119) (check the file %II_SYSTEM%\ingres\version.rel)
* Step 1 of 4 : Choose the file to import and the table to store data.
You can import data from .csv, .dbf and .txt (and no XML here). At this stage the assistant control some parameters like the presence of a cariage return in the file.
Choose the node in the list, then the database here, and the table. If you click on "<new table>" you can choose a table name.
* Step 2 of 4 : File format identification
Choose here how Ingres Import Assistant see your data. Depend on the Separator he know, if you have headers in t your file or not, etc. You can see many tabs (csv1, csv2, etc). Click on the box "Tab correspond to expected result" and click "Next"
* Step 3 of 4 : Column Properties
Choose the column name and properties.
* Step 4 of 4 : Import Preview
Here you have an important thing to take care : Commit every ...
If you uncheck it, the whole file to import will be imported in a single transaction. Depending on your Ingres transaction log file size and the volume of your file you may not complete the action. If you meet this point, you can choose to commit every N rows. Then, transactions will be smaller and can fit your transaction log file size.
If it is not a table creation you have the choice to replace data or insert.
For XML file the only Ingres tools I know is xmlimport (see Command Reference Guide). I'm not an XML expert so I've never try this way (always find some .csv escape).
