Advice: how to convert SQL data?
The two schemas are vastly different - the old one is a MYISAM based system with no FKs and is missing some serious integrity.
My question is - is there some easy way to massage the old data into our new schema?
What I've been working on now is basically to build PHP objects for their old data and then write something to generate SQL statements for our new schema. Since we are using Symfony for the new project, I might also try and hook into Symfony and let it figure out the SQL. This will probably work but its really slow and tedious.