Description: I am trying to reverse engineer from different database schemas. When I do that, Erwin is creating separate data models for each schema. However, my intention is to create subject areas in the same one data model that belong to the different database schemas. How may I achieve that?
While it is not possible to reverse engineer different database schemas into one model file, you can reverse engineer the schemas as separate models and combine them as separate subject areas within the same one model file using the Complete Compare function.
Reverse engineer the separate schemas as two or more separate models. Within each model create a unique subject area and populate the subject area with all the entities. The subject areas need to pre-exist in the models and be pre-populated with their respective entities prior to the comparison.
In the Complete Compare wizard Type Selection link, check on everything under Subject Area (that is normally checked off).
When you press Finish and get the Resolve Differences screen, do not move the tables themselves from the left model to the right model. Instead, export the subject area in the left model to the right model and all of its respective entities will be exported right along with it. That will create that new subject area in the right model and include all its tables along with it.