Yikes, I’m sorry. What were your application developers doing to persist this messy data?
I wrote 'tables' because it wasn't a relational DB although the successor system was.
The amount of data was pretty minimal too, not much more than a dozen GB, but it ate up at least 4 man-years to convert. I still cringe thinking about it. Some parts were an interesting challenge but mostly just soul destroying grind.
of course the value to the business of much of this data is highly questionable, but this isn't always an argument you win..