I'm trying to merge to identical complex database into a single one. The records are different but tables, fields, relations etc are the same. Alternatively I could import the records from one database to another. However I don't know how to do it. When I import records I can only import from one table to another, and I need to transfer them with all the related tables.
It's a public health database where every patient has his own ID and then several tables (with several fields in each table) all related to the patients. For example:
- Table 1: antropomorphic features: height, weight, color of the eyes etc
- Table 2: previous diseases: diabetes, stroke, etc
- Table 3: addres and telephone number
Anyone who can help me?