NW2004s JAVA on MSSQL 2005 - SAP<SID>DB

[arun_ev]

Hello Gurus,

We are planning to install a QA and PROD system on NW2004s SR2 Java Standalone system for portal usage. Now we have a requirement that the PROD data be moved into the QA system after every 'n' months. What is the best approach for this?

1. I take a back up of the PROD database and restore this on QA?

2. A database copy?

3. Do i need to maintain the same SAP<SID>DB user for both PROD & QA systems to ensure smooth functioning?

PS: ALL systems will run on the Windows OS of the same SP and SQL 2005 is of the same level on every server.

Any help in this regard will be greatly appreciated and suitably rewarded.

Thanks,

Arun E V

[Former Member]

Hi Arun,

When you say PRD system will be moved to QA each 'n' months, I suppose you are talking about an strategy for updating the QA data with the last SAP PRD data, which is normally done in some companies.

The easier way to make that is using SAP remote copy client from PRD system to QA system (SCC9). There are several profiles for copying the data (just, data, customizing, profiles, etc), in you case must be just the application data.

Good luck!

[arun_ev]

Hi Jessica,

You are correct. The intention is to replicate the PRD data into QA every "n" months. Can you please provide some more pointers on this SAP remote copy client and its usage. Is this a separate software that is used or comes along with the standard installations? Please provide more information on this.

Thanks for providing these inputs. Your help will be rewarded.

Thanks,

Arun

[Former Member]

Hi,

You can follow the next steps:

1. Login to the client in QA (target client) where you want to copy the PRD data.

2. Execute trx SCC9

3. In 'Selected Profile' choose one of the profiles, depending what you want to copy from PRD. Could be everything (SAP_ALL) or Customizing and Application Data (SAP_APPL). You could use SAP_ALL.

4. Choose the 'Source Destination' . Choose here the PRD system (you have to create first in trx SM59 (QA) an R/3 connection to the PRD system/client).

5. Execute the process choosing the button 'Schedule as Background Job' (since the process will take longer is better to have it in background). The time the process will take depends of the size of your database in PRD.

To monitor the process:

6. Use trx SCC3 (QA). You can double click the entry of your process to see more detail about it (what tables are being copied, tables left, etc).

Hope this helps you.

[arun_ev]

Hi Jessica,

I am talking about a standalone JAVA isntallation here. What you suggest holds good for a ABAP system. On the Java stack any pointers will be of great help.

Thanks,

Arun

[Former Member]

Sorry for the confusion. Then probably what you need to perform is a system homogeneous copy (same db, os). Here you can find detailed information (page 34) :

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000659894&_OBJECT=011000358700006457682006E

The OSS note 970518 https://service.sap.com/sap/support/notes/970518 contains latest information about the pdf.

Hope this helps you.

Regards,