How can we help you today? How can we help you today?

Model management

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?

Aaron N. Cutshall
0

Comments

3 comments

Sort by
  • Dan Jary

    Hi Aaron N. Cutshall 

    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.

    Dan Jary
    0
  • Aaron N. Cutshall

    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

    Aaron N. Cutshall
    0
  • Dan Jary

    Hi there Aaron N. Cutshall 

    My apology for the delay in coming back to you on this!

    Regarding your second paragraph, if you’re looking for a way to automatically shorten object names — for example, having the logical name Customer Detail translate to cust_dtl in the physical model, at the moment, that doesn’t appear to be possible, so this might need to be raised as a feature request. I'll proceed with raising this with our development team today.

    Regarding your question around sub-models, using ‘Subject Areas' may help here. Please refer to our documentation regarding this for both physical and logical models: 

    Logical Model: https://documentation.red-gate.com/rgdm/logical-modeling/model-elements/subject-areas-logical-model

    Physical model: https://documentation.red-gate.com/rgdm/physical-modeling/physical-model-elements/subject-areas-physical-model

     

     

    Dan Jary
    0

Add comment

Please sign in to leave a comment.