I have been working on a php project which has a total no. tables of 124 and the total size of whole DB is `5GB. Now, we are re designing it in Codeigniter and reduced total tables to `40. Now, we were told to get the data of the old DB and to put it in the new one. Here are the situation, the old DB is massive and data is too scattered, in the new version we combined and organized well, so New version has different architecture and mapping. Any suggestions are heart-fully loved.