In the first place, TDM3 does not support multiple databases.
What you can do is, import all databases into single model.
But there is problem when the databases contain same tables.
You can’t have multiple entities with the same name in one model.
And the inheritance is for extending entities in logical model.
Inheritance in physical model is possible for postgresql. Both inheritances
extend one table by adding additional attributes/fields. It is is not possible
to alter database structure.
If you want to synchronize altered tables, you have to have each database in separate model (reverse engineered) and compare these models with comparer tool (in TDM3).
Let’s say MASTER is the oriinal model from which you created copies.
“inherited” or “copy” database is the copy. It can contain additional fields, tables, changes.
What I would do is :
reverse engineer all databases, each to single physical model (that actually happens when you reverse engineer).
reverse engineer master database (if you do not have it as a model already) into separate model.
compare this model to other models, importing additiional tables to master database, maybe also new attributes of tables in those inherited databases.
recreate referential integrity (relationships) between old tables in MASTER database model and imported tables/fields from “inherited” database models.
Now you have master database model with all the relevant changes in copies that should be, or are a ood addition to the master database.
For each database copy create separate workspace on master database model, containing tables that exist or should exist there. If you plan to uprade all databases to the same liking, there is no need to do this.
No you can compare the master database model to each “copy”
and create specific alter script for each database.
Using separate databases with referential integrity would be good for me only in two situations: If you have multiple customers that from time to time do some alternations in their databases themself and you want to clean up the mess, or to separate tables in “categories” that exist in different databases. The mix of these two is not good, and my list will not help you in such a scenario (in TDM3).