Client Refresh from Production to QA

[Former Member]

Hi,

In our landscape CRM,BI,XI and EP components . We wanted to do client refresh from Production data to QA .We are using Widows and MSSQL 2005 database.

We have some doubts, since we have go-live date very soon it would be great help if some one can suggest step by step so that we will save time to complte this task

1. What is the procedure to do client refresh ?

2.What is the post configuration steps for client refresh ? like logical system change , and etc

3.Since we are integrated Portal with CRM and BI in QA after refreshing production data to QA ,is that settings will distrub ?

4. Do i need to do client refresh for all the components CRM,BI,XI or only Source system (CRM) is enough ?

5. We have CRM production system client 990 and logical system BAPCLNT990 , QA CRM client 880 and BAQCLNT880 so once i refresh production client to QA , is QA client will be remain 880 or it will replace as production client990 ?

We have seen some of the SDN docs it will not give complete picture , it would be really great help if you give more

- Kristene

[Former Member]

Hi

There are few ways by which you can do the client refresh.

- By restoring the backup of production on quality and recreating the conrol file and changing the SIDs. you can find the documents on Sdn. But here the client would be same as that of production.

Read this link: /people/sumit.khullar2/blog/2005/12/20/quickest-way-to-change-sid-of-oracle-based-sap-system

- By client import/export utility. In this you can export the production client and import it to Quality. Here in this, you can have the desired client number in quality.

But here you have to take the downtime as import/export would take the huge amount of resources.

Read this message :

Thanks