IDM System Copy

[Former Member]

Dear Friends,

We have a requirement to copy the Production IDM system on to the QA system in order to synchronize the landscapes...The following IDM schemas do exists on both PROD and QA oracle Databases...

MXMC_OPER (147 Tables)

MXMC_RT (318 Tables)

Can we simply use the Oracle Export and Import procedure to copy the IDM schemas from source to destination? Will this be enough in order to synchronize the landscapes?

Will this procedure copy all the Scripts, Jobs, Policies and other necessary settings to run the IDM?

Truly appreciate all your support and response...

Thank you,

Nikee Cheella

[former_member2987]

Hi Nikee,

Please take a look at this document for more information: SAP NetWeaver Identity Management System Copy G... | SCN

Regards,

Matt

[Former Member]

Hello Matt,

Thank you. I have gone thru the documentation of which you have pointed...Much appreciate it...

I am also looking for a DB level system copy procedure if there is any?

Thank you,

Nikee Cheella

[former_member2987]

Nikee,

To the best of my knowledge, that approach does not currently have any best practices dictated by SAP (I do not work for SAP so this is not an official statement)

My commendation is to work with your DBAs on this. This is a very delicate matter and I would not want to lead you down the wrong path as I am not a DBA.

However, whatever approach you choose, I will say this, make sure you have good backups and have tested this thoroughly before doing any work with Productive systems.  I'm pretty sure you know that already, but it bears repeating...

Regards,

Matt

[Former Member]

Matt,

Are you aware of the procedure being compatible with IDM 7.2.4.  Current scripts are failing with the following error:

29.10.2015 16:49:00 :I:Parsing arguments to syncutility

29.10.2015 16:49:00 :I:Creating connection to jdbc:sqlserver://XXX-XXXXXXXX:1433;databasename=mxmc_db;user=mxmc_admin;password=*********

29.10.2015 16:49:00 :I:Severity for 'com.sap.idm' set to 3 Logging to :C:\usr\sap\IdM\Identity Center\ImXport.log.trc

29.10.2015 16:49:01 :I:Beginning import process

29.10.2015 16:49:01 :I:Importing with imXport version v.7.2.4-720_REL-BUILD-13.05.2012_18:33:39

29.10.2015 16:49:02 :I:File exported with imXport version v.7.2.7-720_VAL_REL-BUILD-09.01.2013_10:08:16

29.10.2015 16:49:02 :F:The import file contains a newer db version than the database, import is not allowed

29.10.2015 16:49:02 :I:Rolling back

Thanks in advance,

binoy

[former_member2987]

Binoy,

I'd suggest checking for a later version or opening a Ticket.

Matt