BW Client Copy

[Former Member]

Hi,

I would like to clarify the following.

Objective :

We would like to copy the BW Production system's Client 900 to another BW system. ( SAP_ALL Profile )

The purpose is just to have a backup system for reference.

( only 1 user will access the system. )

Differences found between the Source and Target Systems:

1. Source Windows x64 / Target: Windows x86

2. Source : Server / Target : High End PC.

3. Source : MS SQL SERVER 2005 (patch XXX) / Target : MS SQL SERVER 2005 (patch YYY)

4. Source : ST-PI 2008_1_700 (0000) / Target : ST-PI 2005_1_700 (0006)

5. SAP_BASIS 700 ( SP15) / SAP_BASIS 700(SP15)

(Remark : All other SPs are same except ST-PI)

Important Note:

Even if some tables belong to ST-PI doesnot get copied,

it seems to be OK with the Customer as he will use the system very sparingly

especially for reference purposes.

But the system should be usable eventhough it may be inconsistent.

Keeping the above in mind, could you tell me which will work.

1. Client Export and Import.

2. Remote Client Copy.

(RFC Dictionary comparision showed 2 table inconsistency which belong to ST-PI)

3. Is there any other way to achieve this ???

Thanks & Best Regards

Raghunahth L

[former_member524429 · Accepted solution]

Hi,

1. Source Windows x64 / Target: Windows x86

Remote copies or client transports can also be carried out between different database and operating systems.

Please refer SAP Note Note 552711 - FAQ: Client copy to get more info.

Keeping the above in mind, could you tell me which will work.
1. Client Export and Import.
2. Remote Client Copy.
(RFC Dictionary comparision showed 2 table inconsistency which belong to ST-PI)

-> First determine the size of Source Client which you want to Copy.

Please follow this SAP Note 118823 CC-ADMIN: Size of a client to get more info.

->Same Support patch level at both Source and Target System is recommended. but in case of Add-On difference, you can exclude the Tables some tables without any termination (using RSCC_PACKAGE report ). Please refer this SAP Note Note 557132 - CC-TOPIC: Remote client copy to get more information.

-> If the Size of Source Client, based on the selected Client Copy Profile, is not so big, then you can do Remote Client copy or Client Export/Import. If its big then i will recommend to do System Copy using Database Specific Method or read this Useful SAP Note 489690 - CC INFO: Copying large production clients

-> Perform Test run before performing actual client copy(in case of Remote Client Copy).

Upon Error, you will have to do Table/Object adjustment in Target System.

3. Is there any other way to achieve this ???

System Copy using Database Independent Method or using Database Specific Method (detach/attach method).

Regards,

Bhavik G. Shroff

[ken_halvorsen2]

3. Is there any other way to achieve this ???

Yes, I'd do a Database restore from a SQL Backup of the Source system.

At the very least you won't have to have the Production system down as yopu need for the client copy process.

Ken