Hello all,
I have a question about DB modeling. In the forum a similar aspect has been covered a couple of times, unfortunately I didn't manage to apply the result to our UseCase. Maybe I just didn't understand it correctly. I really hope someone of you can help me.
We want to maintain a DB schema in the EA that can be used in several RDBMS. Since these differ of course in detail, we want to create a generic model that applies to all DBs. However, an RDBMS-specific table element is then to be derived from each table, in which the RDBMS-specific properties are then maintained. If no changes have been made in the specific table element, then of course the definitions and properties of the parent element should be adopted.
At the end of the process, we would then like to have an RDBMS-specific DDL script created of course.
So far I have tried a lot with "Child Elements". That didn't look too bad. Unfortunately the column definitions of the parent are not taken over, so that a generation of the DDL script failed with the error that no column definitions exist.
Then I tried it with "Clone Structure as new version". But there a completely new element is inserted, which has no further connection to the original object. At least I didn't get it to work that way.
Can someone here help me how to do this? Of course, our main goal is to define a table only once, if possible, and to maintain the RDBMS-specific deviations separately.
I am looking forward to your answers! Thanks a lot!
