on 06-03-2009 7:17 AM
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
Hi,
You can do the same with Client Export/Import.
-Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.