Iam not sure what is MOS but our current version is the following one Oracle Business Intelligence 12.2.1.2.0

found ORACLE_HOME/bifoundation/server/bin/xudml_mds_core.xsd file i thought this is the file you were suggesting

Thanks for the help.. but iam not sure how to open the xsd file & find the relation. Any pointer would be helpful

I meant Prod* not DEV in above comment

Hi, i was trying to recreate a scenario i am facing in dev instances. I have a server A on DB A has metadata schema's. Similarly server B with DB B has again those schema's. So now I have to merge above 2 into 1 DB's schema without any loss of data. Like any scheduled jobs should not get affected. Here when i mean schemas…