Q
Problem solve Get help with specific problems with your technologies, process and projects.

Options for refreshing data in TEST and QA systems

We are running SAP 4.6C on UNIX/DB2 R/3 along with BW and APO. We refreshed our TEST and QA systems over a year back and are now in a dire need of refreshing the same for R/3, BW and APO. With PRD systems overgrown over the time, it?s almost impossible to replicate the full database. We just need a good amount of data in TEST and QA system so developers can test their configuration and programs. What are the different options available to us? What are the different third party tools we can use to refresh our QA and TEST systems? We are planning to refresh every six months from now on. What is the general refresh strategy across the SAP sites? A couple of options I found on discussion boards are: Make homogenous copy; use eCATT or LSMW; use SAP import/export (not a good option for big DB) etc. Our goal is not to replicate the entire PRD database and at the same time have a good sizable data in the QA and TEST environment.
Since a homogeneous system copy is not a good solution for you, you will need to use ALE to move data. This might be a bit of work in the beginning, though. As far as third party tools, I suggest you take a look at InfoShuttle from Gamma Technologies. This tool allows you to move specific data.
This was last published in November 2004

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close