Expert: Jean-Pierre Zuate Date: 6/22/2007 Subject: Ingres database windows to linux
Question 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.
Regards,
Jean-Pierre Zuate
---------- FOLLOW-UP ----------
QUESTION: Thanks for the useful reply. I'll try this approach asap.
Is it possible to unload only the checkpoint data?
The initial situation is like this.
We are planning to deploy 3 windows ingres database on different sites. These servers are not connected nor replicated. What we wanna do is to get everyday the backup data for that day(not the whole database) from these windows ingres servers and upload/reload it on Linux central server with each own corresponding database.
We are currently using Powerbuilder & microsoft sql server for development. But we're moving to Ingres database for production.
Any hints is helpful.
Thanks again.
JB
Answer Hello,
The only way you have is to use Ingres/Replicator. The only need you have to replicate your data is to have unique key on each table (with sequence in columns now it is easy). Replicator work on 3 stages :
- capture data modification
- distribute data (he say where data go)
- replicate
The last stage can be done all day (or night) long, or can be done one time by day ...
Move checkpoint from a machine to an other can be done, for sure, but not from windows to linux. Each database have a special file, aaaaaaaa.cnf, and it contain for example the locations names of the database and ... the path of the location area. It is not the same from windows to linux ... You can move Ingres files from a machine to an other if you have some key condtions honoured :
- same type os machine( OS, version)
- same architecture (same file systems)
- same name of locations, directory for those locations
- same Ingres logging system configuration
- etc
and at least it is not supported by Ingres (it mean if you loose data it is your entire problem).
