Migration of old legacy data (mySQL) to a new database (mySQL). Data otputs are in XML.

I need to migrate XML data from an old? legacy database (mySQL) which uses an old DTD/Schema (or maybe a corrupt schema) to a new SQL database which uses a new DTD/schema and has a XML upload function. I have the new DTD/schema. I have to find a way of mapping the old XML outputs to the new XML schema so that i can upload the XML files without error messages. I have limited time to get this data migrated. ## Deliverables I have attached a schema and DTD of the new XML format.