oracle-sqldeveloperentity-relationshiporacle-sql-data-modeler

How to save the node positions of an entity-relationship (ER) diagram in Sql Developer


I have generated an ER Diagram for a schema with lots of tables, by following this approach

After generating it, I re-positioned all the nodes (tables) in the diagram (Relational Model) so that they are grouped by the functionality they provide. This took me quite long.

What I want now is, to save the state of the diagram so that in the future, when the schema is moved to a new version, I just import the new tables without loosing the positions of the existing tables in the diagram.

I cannot find a way to do it. I right-clicked on my Design (in the Data modeler Browser view on the left) and selected Save Design. It created a directory with multiple sub-directories and files. But I do not know how to load that design again, which I suppose will contain the state of my Relational Model.


Solution

  • When you save your design, it ALSO saves the positioning of the entities or tables and their relationships in the digram(s).

    Starting from scratch, a new design

    I'll import data from my database, using HR schema

    And once it's in, i'm going to re-arrange the diagram objects a bit...

    enter image description here

    Now it's time to SAVE the design -

    enter image description here

    I've placed it in a designs folder i have under my user HOME.

    After hitting save, you can see where/what is saved/created

    2024-07-08 11:31:30 - Design my-new-design saved. (/Users/thatjeffsmith/modeler/my-new-design)
    

    And if we go browse that folder...

    enter image description here

    That 'dmd' file is what you'll be opening when you want to work with your design again.

    So if I close the design and re-open it, we make it pretty easy.

    Just use the Recent Designs item on the File menu.

    enter image description here

    If you can't find your design, just look for the DMD files on your machine.