Having issue with the conversion from logical to physical (basically each time during convert, attributes in subtypes get duplicated inside the containing table - likewise the table fills up with more and more duplicated check constraints).
The problem is as follows:
Create a logical model with an entity Employee and a subtype InternalEmployee. The inheritance is set up as exclusive. The subtype has one attribute, “Bonus”.
Next use the Convertor to merge the logical model into a physical model. The first time it works fine, we get a table called “Employee” with a column “Bonus”.
The problem is that each time we run the convertor from then on, it creates a new column called “Bonus” in the table. It also creates the check constraint needed to enforce mandatoriness on the Bonus column, even though it already exists in the table.
Have looked all over but can’t work out how to stop this. It seemed like unable to reliably merge the logical model into an existing physical model, when there are subtypes involved.
Will the Sync & Convert Wizard in BETA resolve the problem?