Are all the environments using the same MDM version? You can clone ORS from one environment and export/import into the target ORS on another environment.
1 of 1 people found this helpful
If you only want to clone the data and not the configuration, you can consider leaving out the C_REPOS_* and C_REPAR_* tables which have the configuration for the ORS metadata.
One disadvantage will be that you will need to ensure that the configuration has the correct schema (tables/columns) for your configuration between the 2 environments, otherwise the import process will fail and will cause you unintended issues.
A better approach might be to do it 2 steps, where you take an export of your Current Metadata, clone the environment and use the original changelist to revert the configuration back to what it is. This approach might be a little time consuming but will provide you a better process where the developers can baseline and leave out any unintended configuration changes as well.
Subbu Dont think probably a good idea to clone only non-REPOS tables and objects.
Many things may go out-of-sync like ROWID sequences, Match rule ids in MTCH and HMRG tables. Also some objects maybe in METADATA but not physically in DB.
Our recommended approach is to follow Anuvinda's answer by cloning entire schema and re-import the changelist