Expert: Jean-Pierre Zuate Date: 1/10/2007 Subject: Export Db and import into another db
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
