Hope you are well. This is a scenario we have helped many customers with. As Gavin mentioned the Alderstone CMT solution can migrate data from MSSQL to Oracle at the database level maintaining all relationships and data integrity as well as doing all necessary conversation for the database particulars.
We had one customer who spent 12 months trying to develop and model the Remedy data model, after which they reached out to us and we were able to migrate from SQL to Oracle in a couple of months.
Let me know if this is of interest. Feel free to reach out.
mobile: +1 650 308 4633
Revolutionise your management of BMC Remedy ITSM Services with CMT