cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Client 000 config table entries to target client

0 Kudos

Hello

We need to copy some Config entries of a Table from Client 000 to XXX. How Can this be done? I tried thru SCMP, SCU0, but unsuccessful. After the comparison thru the above t.codes , the Adjust option is grayed out. Any ideas/help is greatly appreciated.

Thanks

Vidyadhart

Former Member
0 Kudos

This is how you do a export and import of table entries.

Export:

Open Notepad and type the following,

export

client = 000

file = 'clone.export.<sid>.<client no>.data'

select * from <client_dependent_tablename1>

select * from <client_dependent_tablename2>

........................................

........................................

select * from <client_dependent_tablenamen>

Save the file as export.ctl

Run R3trans export.ctl

and the data of these files will be stored in a file called clone.export.<sid>.data in the directory from which you have called R3trans

Import:

Open Notepad,

import

client = XXX

file = clone.export.<sid>.<client no>.data

buffersync = yes

Save the file as import.ctl

Run R3trans import.ctl

Cheers!

Bidwan

Accepted Solutions (0)

Answers (0)