Comments
2 comments
-
Thanks for reaching out to us regarding this, our apology for the delay in coming back to you!
There isn’t currently possible to automatically reorganize or rearrange entities based on their relationships, this is a manual process.
Regarding generating models, as detailed in our documentation (here), you can generate a physical model from a logical model. However, reverse migration—from physical back to logical—is not supported.
I hope this helps.
-
Thank you, Dan. I realize that an algorithm exists for arranging a model when a SQL script is imported. Extending that to allow for re-arranging is something that I would suppose to be possible, so I look forward to that. I also recognize that reverse migrations can be difficult, but they are very useful!
In reviewing the documentation you provided, I could not help but notice that there is no transition between a logical name and a physical name. The logical names were used as physical names. Having them separate is very handy as physical databases may have different naming requirements. Logical models are for documentation and should support fuller names than get translated into physical names given keyword substitutions. For example, the logical name Customer Detail could get consistentl translated to cust_dtl.
My second question got overlooked, but I fear I know the answer to it: Also important in large models is the ability to have sub-models to better organize diagrams. It would allow diagrams for portions of the model with entities shared between sub-models. Is this possible?
Thanks,
Aaron
Add comment
Please sign in to leave a comment.
I need a way to reorganize or rearrange entities according to relationships. Manually moving entities is difficult with large models.
Also important in large models is the ability to have sub-models to better organize diagrams. It would allow diagrams for portions of the model with entities shared between sub-models.
Is there a way to migrate a logical model to physical and vice versa?