Hallo, I'm trying to migrate a lot of values from a database (MS Access mdb via odbc) to another mysql database (from which I'll start to build a RoR based application), using the ruby-odbc library I can access the datas in the mdb file, I would like that some important things, like the ids in the tables, will be the same in the two databases (all the foreign keys are already set in the mdb, so why do I have to compute them again?), table structure will be a bit different, the mysql based one will be more refined than the old software one, but most of the structure could be inherited from the mdb one. Thus I'm looking for a way not to waste all the informations that are already present, a.k.a. the joins already in place (without having to use two ids, the rails one and another field for the referenced one, this looks clumsy to me...).
Thank for the answer