Expert: Jean-Pierre Zuate - 1/10/2007

Question
I Jean,
we would like to export data from node1:database and import into node2:db (same name)
Can you give us some good stuff...we are an Oracle Competence centre and new about ingres....

thxs

Ingres II rel 2.6

Answer
Hello,

Suppose your machines call A and B, A is the source one, B the destination

1/ connect to B
2/ create a vnode (virtual node) with a tools named netutil
A virtual node is :
- a name
- a user on the machine A
- the password of the user
- a machine address (name, IP, ...) : the name of the machine A
- an Ingres listen address (ingprenv II_INSTALLATION on machine A)
- a protocol (tcpip, etc)
3/ create a directory, and go into the directory
4/ unloaddb -c thenode::thedatabase
-c to have an ASCII output of data (for porting it is better)
5/ ./unload.ing (if you are on Unix) or unload.bat (on windows)
6/ Edit reload.ing or reload.bat to cut the reference to the node
7/ ./reload.ing (Unix) or reload.bat

If you need more information you can look for the following in the official documentation :
- netutil
- unloaddb
- copydb

Hope this help,
Jean-Pierre Zuate
La Fage Conseil
jpzuate@gmail.com