I need to migrate the informix DB to mysql. However, the database schemas of the source/destination are slight different. (2 tables from informix are merged into 1 in mysql)
informix table1 informix2 table2 -> mysql table3
WHat i am trying to do is to export the informix data into insert script, execute the scrip to create the data of the 2 tables in mysql. The run a final scipt which joins the data of the 2 to insert the data to the final table3.
Can anyone let me know how i can achieve that?