cancel
Showing results for 
Search instead for 
Did you mean: 

copying only the application data from prod to qa.

Former Member
0 Kudos

we have sap ecc6 dev-qa-prod landscape.

we also have various other components like xi,mi,ep,bi,bi_java,dms,duet etc. new components on different servers. ecc6 servers have been configured to interact with all these new components.

Now, we have a requirement to copy only the application data (no customising or configuration) from ECC6-Production to ECC6-Quality system. we need to do this without disturbing the configuration that is done in ecc6-qa system for all above mentioned new components.

In client-copy profiles we do not find any profile for copying only the application data from prod to qa.

Which client-copy profile can be used for this purpose?

any other simple method could you recommend?

Thanks in advance.

sunil

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I would tend to agree with James

Yes you can use the SAP_ALL profile to copy to a NEW client on QAS.

And yes, the customizing within existing QAS clients will be unaffected.

However, you may need to consider client-independent configurations and ABAP programs.

Will you be exporting client-independent objects as part of the SAP_ALL profile ?

If not, will you be using the current ABAP programs in QAS ?

What if ABAP programs are overwritten in QAS ?

How much development activities are currently underway ?

It may work 90% of the time, but if you are in an environment in which everything must be 100% accurate, there are risks in such an exercise, and in BASIS, it's not the 99% of the time that things went well, it's the other 1% of the time.

Former Member
0 Kudos

We have an ECC5 system and perform client exports from production back to dev and qa for testing purposes.

So far we havn't come across any issues in using scc8 using profile SAP_ALL (without change documents) .

We also have XI,SRM,ESS,MSS(portal) linked into this on dev and QA as well.

The reason for this is that we have 6000+ staff on SAP HR/PY and ESS, the client copies give our developers and system analysts valid data to test against in their dev / qa environments.

The backup clients are locked against config, so any tranports havs to be scc'd into them , ensuring landscape integraty.

Or specified , when going into the QA system.

The cilent export and import doesn't impact configuration in the DEV/QA systems, and we have had no reports of any problems when using this method numerous times now.

You just need to create a new client as the target system in DEV/QA as the home for the data, and make sure you have enough space.

Regards

James

P.S. If you want to test everything you will have to let your config people know about a new client, as RFC' etc will be needed.

Edited by: James Ibbotson on Jan 23, 2008 10:37 AM

Edited by: James Ibbotson on Jan 23, 2008 10:38 AM

Former Member
0 Kudos

Hi,

There is no logic to copy only data from prod to QA.

The customizing may be different in QA so the data copied could break the data integrity.

That is why you don't find a client-copy profile for that.

The only possible way would be to use a tool like TDMS but it is very complicated and time consuming.

The solution used by 99% of SAP customers is a database refresh from prod to QA...

Regards,

Olivier

Former Member
0 Kudos

Dear Olivier,

Thanks for your reply.

Actually we were also using homogeneous database copy to refresh our ECC-QA system from ECC-P01.

But now, we also have various other components like xi,mi,ep,bi,bi_java,dms,duet etc. These new components are on different servers. ecc6-qa server has been configured to interact/interface/communicate with the QA servers of all these new components. Also, there is Single Sign On (SSO) setup between QA server of ECC6 and QA servers of all these new components.

When we copy database from ecc-prod to ecc-qa - all this configuration/setup in ecc-qa will be overwritten. That is the problem.

How do we get data from ecc-prod to ecc-qa without distrubing the configuartion/setup in ecc6-qa server that is done for new components like xi, ep, dms, duet.........?

thanks

Sunil.

Edited by: Sunil Mouje on Jan 24, 2008 6:53 AM

Former Member
0 Kudos

Hi Sunil,

>When we copy database from ecc-prod to ecc-qa - all this configuration/setup in >ecc-qa will be overwritten. That is the problem.

Of course, we have the same problem in my company. The complexity of the database refresh increases with each new project and each new connection.

That is why our refresh specific procedure has grown from 10 pages up to 50 pages over the years....

We did not find any better solution.

Regards,

Olivier