Transport table+data one server to another server

[Former Member]

Hi expert,

i have 2 servers DEV1 & DEV 2 with ecc 6.0 oracle 10g.

Both server have same patch level and same version of OS,DB & Patch.

in DEV1 have a table which consist 54500 rows i want move to this table and data in DEV2 server.

Please suggest How can i do this if i create a transport or copies request it move only structure not data.

Regards,

[sunny_pahuja2 · Accepted solution]

Hi,

You can export table from your DEV1 and import table to DEV2 using brtools.

Thanks

Sunny

[Former Member · Accepted solution]

can i do this via sap ???

[sunny_pahuja2 · Accepted solution]

Hi.

I don't think so.

Thanks

Sunny

[former_member188883 · Accepted solution]

Hi Vivek,

In case it is a customer table ( Z/Y) or Standard SAP customizing table, you may include the table structure and contents into a transport request and import the same into target system.

You may create a transport request using SE01.

Include following objects into the transport request

R3TR TABL <TABLENAME>

R3TR TABU <TABLENAME>

Regards,

Deepak Kori

[Former Member]

Hi,

It is possible through SAP by creating transport request.

See the below link for how to:

Transporting Table entries from one server to another

[http://saptechnical.com/Tips/Basis/Transport/TableEntries.htm|http://saptechnical.com/Tips/Basis/Transport/TableEntries.htm]

Regards.

Rajesh Narkhede

[Former Member]

Thanks got it..