Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Download and upload to same table in different servers

SAPSeeker
Participant
0 Kudos

Dear Experts,

I need to download data from few tables from one server and upload the data into same set of tables in a different server.

These tables contain millions of records

What is the best way to acheive this ? What are the Transactions/Tools required to achieve this ?

Thanks & Regards,

Gaurav.

5 REPLIES 5

former_member202771
Contributor
0 Kudos

Hi Gaurav,

Use ARCHIVFILE_SERVER_TO_TABLE and ARCHIVFILE_TABLE_TO_SERVER.

Thanks,

Anil

Former Member
0 Kudos

Dear Gaurav,

  Please let us know if the data is standard data and we have some IDOCS for this, then better transfer the data using IDOCS. Else if your client have PI system  you can opt for Proxy also. Please elaborate your requirement.

Thanks,

Prakash

former_member187748
Active Contributor
0 Kudos

Hi Gaurav,

if both of servers are application server, then you can use txn given below.

To Upload file to application server use T-Code: cg3z

To Download file from application server use T-Code: cg3y

0 Kudos

Hi Sanjeev,

Can you please let me know, how to use these Transactions for uploading/downloading data in Table ? I find them only useful for file movements between Desktop and Server.

Thanks & Regards,

Gaurav.

0 Kudos

Hi Gaurav.

Please go through these link, they have provided some useful methods.

http://scn.sap.com/thread/288716

http://scn.sap.com/thread/772185