Databases reconciliation - Urgent !!!
Posted on 1999-01-19
At the start of a project I had one master database which holded central information. I provided copies of that database to different people, *for info only*. Of course they used it and built on it, adding information (no new tables/relationships... just new data in existing tables).
Murphy came around (read management) and decided that the new information in the different database is extremely valuable and should be compiled.
Problem then : I now need to combine those databases into one. Trouble is, most of the tables have fields which are unique(autonumber, sequential). And the data which I need to combine is spread over several tables (relationships exist), each with unique numberings. But those unique number per database, I will of course find them more than once when I try to combine the different databases.
Any suggestion on how to solve that problem ?