System copy from Non-MCOD to MCOD system

[Former Member]

Hi

We have a situation where we need to do a system copy for the following scenario..

System - 1: Non-MCOD, SID=BW4

System - 2: MCOD, SID=BW1 & BW2

We would like to perform a system copy from BW4 to BW1..

Kindly highlight the steps..

Thanks & Regards

Madhu

[Former Member]

I would wonder if note <a href="http://service.sap.com/sap/support/notes/1003028">1003028</a> won't do this job too?

peter

[Former Member]

Hi

I have used the FROMUSER and TOUSER option of the IMPORT cmd to perform a system copy like you have described.

Steps:

1) Export BW4 (EXPORT USER=SAPBW4 ... )

2) In MCOD database, delete/drop all objects belonging to SAPBW1. From memory, I think I found it easier to DROP USER SAPBW1 CASCADE and the recreate the SAPBW1 user.

3) Import BW4 export (IMPORT FROMUSER=SAPBW4 TOUSER=SAPBW1 ..)

I don't use MCOD anymore because it is such a pain to refresh the systems.

Regards

Doug

[former_member204746]

You found one of the many reasons why I would avoid using MCOD at all.

I prefer having 2 databases on 1 system using their own databsaes... but that's just me.

I would investigate usage of the homogeneous system copy guide from http://service.sap.com/INSTGUIDES

this must be your only workaround.

Good luck.