Expert: Jean-Pierre Zuate Date: 6/21/2007 Subject: Ingres database windows to linux
Question Can anyone provide the steps to transfer Ingres database from windows to linux (debian) and vice versa.
I'v tried it with unloaddb but it did'nt work.
Any help would be appreciated.
Many thanks
JB
Answer Hello,
To transfer Ingres data from any platform to any, you must take care of the following from both side (unix and windows, or a box and an other) :
- same locations name
- database must be extended to the same population of extension
- same value for : II_DECIMAL, II_DATE_FORMAT, II_DATE_CENTURY_BOUNDARY, II_MONEY_PREC, II_MONEY_FORMAT
- use the option -c for copydb or unloaddb. -c mean "ASCII format" vs "binary format"
- same population of users in both boxes
So, from machine one, you do something like :
mkdir directory
cd directory
unloaddb -c my_database
./unload.ing
cd ..
tar cvf directory.tar directory
Binary ftp this file to the other box
tar xvf directory.tar
cd directory
Edit copy.in to check :
- the path of the file iiud.scr & iiud65.scr (it must exist on the target machine)
- the path of the files for SQL sentences COPY TABLE ... FROM
Edit reload.ing to check :
- the path of the file copy.in
- the name of the database
./reload.ing (the database must exist and extend to the correct locations)
Hope this is clear and at least helpfull for your issue. Let me know if you need further comments of the procedure.