I have to migrate from one forums-software to another. So I have two different schemas in MySQL5. I want to migrate from the old one to the new one. I already did the main work: I analysed the tables and found the mapping. Now I am looking for an application, which helps me to migrate the data.
For the migration I have to read the dara from the source schema, transform it a little bit and write it to the target schema (different tables and different columns).
I tried out JasperETL but this wasn't really successful.
Does anyone has an idea, how this could work? I have programming (Java, Ruby, PHP) and modelling (UML) skills.