Table EXPORT/IMPORT using R3trans

Features
Possible regardless of OS, DB

 

 

EXPORT control file

export
client=XXX
file='<PATH>/<FILE NAME>.DMP'
select * from <TABLE NAME>
...
select * from <TABLE NAME>

 

EXPORT COMMAND

R3trans -w <FILE NAME>.LOG <FILE NAME>.CTL

 

 

IMPORT control file

import
client=xxx
file='<PATH>/<FILE NAME>.DMP

 

IMPORT command

R3trans -w <FILE NAME>.LOG <FILE NAME>.CTL