12-31-2013 8:29 AM
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.
12-31-2013 9:17 AM
Hi Gaurav,
Use ARCHIVFILE_SERVER_TO_TABLE and ARCHIVFILE_TABLE_TO_SERVER.
Thanks,
Anil
12-31-2013 9:23 AM
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
12-31-2013 9:24 AM
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
12-31-2013 11:52 AM
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.
12-31-2013 12:10 PM
Hi Gaurav.
Please go through these link, they have provided some useful methods.