We had to work with a similar situation and we ended up using a RDM export and merge with RDM json generated for new source system and joined them together in python.
------------------------------
Harsha Karumuri
Dodge Data and Analytics
Hamilton TownshiP NJ
------------------------------