AnsweredAssumed Answered

How to combine to complex database (merge or import)

Question asked by dorcaratto.dimitri@gmail.com on Nov 20, 2018

Hi,

 

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

etc

 

Anyone who can help me?

 

Thank you

Outcomes