cancel
Showing results for 
Search instead for 
Did you mean: 

Trasporting standard tables from one SAP server to the other

Former Member
0 Kudos

Hello SAp Experts!

We have one R/3 server and a BI server which is being used from past one year. Now we have installed new R/3 and BI servers with higher configurations. We need to transport all the tables/data from the old server to the new. Can anyone suggest solution for this task.

Thanks a lot for your inputs.

Regards

Vanitha

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can do the same with Client Export/Import.

-Srini

Former Member
0 Kudos

Hi,

I shall suggest to have System Copy because this table should be used with other once.

or you can do it another way at database level.

you using Oracle Database, try the Oracle tools exp/imp

Here na example

How to export

orazmj> exp

Export: Release 8.1.7.4.0 - Production on Sun Jul 25 14:34:24 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Username: sapr3

Password: <= SAPR3 pass

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production

With the Partitioning and Parallel Server options

JServer Release 8.1.7.4.0 - Production

Enter array fetch buffer size: 4096 >

Export file: expdat.dmp >

(2)U(sers), or (3)T(ables): (2)U > 3 <= 3 de tabelas

Export table data (yes/no): yes > <= ENTER

Compress extents (yes/no): yes > <= ENTER

Export done in WE8DEC character set and WE8DEC NCHAR character set

About to export specified tables via Conventional Path ...

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > <= nome da

tabela

Exemplo:

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > TBTCO

. . exporting table TBTCO 292302 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > TBTCP

. . exporting table TBTCP 293902 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > TPRI_PAR

. . exporting table TPRI_PAR 1980 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > ENTER

How to import

orazmp> imp IGNORE=Y FILE=expdat_zmj.dmp

Import: Release 8.1.7.4.0 - Production on Sun Jul 25 14:39:26 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Username: sapr3

Password:

.

Thanks

Rishi Abrol

Former Member
0 Kudos

Hi Rishi,

Thank you for your quick response. We cannot perform system copy as the servers are already installed and ready to use. We need to copy all the tables/data from the old server to the new so that the consulants can continue with their work without missing any of their data. And the database we are using is MS SQl server. Is it possible to do a transport. If yes, Can you please let us know how we can do that. Both the systems are standalone and not integrated to each other.

Thanks a lot

regards

Vanitha

Former Member
0 Kudos

you can perform remote Client Copy /Client Refresh.

Thanks Rishi Abrol

Former Member
0 Kudos

Here are the steps to perform Remote Client Copy/Client Refresh.

Scc9 for the remote client copy.

for this you have to make an rfc for the data copying in SM59.

Steps for Client Refresh.

First you need to Configure the Stms in both the system.

Then from the source system you can Export the client by transaction SCC8 .

When the export completes there shall be two transport created in the STMS queue.

Trans port these request to the target System.

Now importthe request by SCC7 in the target System.

Thanks

Rishi Abrol