I’m working on a long term project with multiple phases and would like to have a single model to handle our database design and DDL generation for all phases. I’d like to be able to have entities/attributes in the model that we don’t expect until later phases but still generate DDL for just phase 1. So for example I’d like to have say 50 entities in my model and mark 10 of them as “Phase 1.” Similarly, even within those 10 entities for phase 1, I’d like to be able to add attributes that aren’t expected until later phases (and somehow mark them as “Phase 1” too), so you might have 8 attributes that are for phase 1 and 3 that are for other phases. When generating DDL, I’d like to be able to generate just the 10 entities and 8 attributes.
I thought about using the “generate” checkbox but that only seems to apply to entities and not attributes. Then I created a custom property on PEREntityMS08 and PERAttributeMS08 called “TargetPhase” thinking I could generage DDL based on that. If I couldn’t generate DDL based on that property I figured I could create a new model called “MyModel_Phase1” and just copy over the entities/attributes marked with “Phase 1” from the main model via a script into the second model and then just use the second model to generate my DDL. Alternatively I could just copy the original model’s file to a whole new file, open that and then have a script delete any attributes/entities that aren’t marked as phase 1. I actually tried that last approach and got all kinds of “access denied” messages so before spending more time on it I wondered if there is a “built in” or better way to approach this.