Exporting and importing sap tables with controlfile

Exporting client

In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content.

EXPORT

client = 500

file = export_file

select * from VARI

select * from VARID

select * from VARIT

select * from VARIS

select * from VARINUM

and execute following command

R3trans -w /usr/sap/trans/bin/vari_exp.log -u 1 /usr/sap/trans/bin/controlfile_export

Import

In order to import the exported tables into target client, create a controlfile /usr/sap/trans/bin/controlfile_import with the following content

IMPORT

client = 500

file = export_file

execute following command on target system.

R3trans -w /usr/sap/trans/bin/vari_imp.log -u 1 /usr/sap/trans/bin/controlfile_import

Leave a Reply