[PAETEC Communications]

Using the database explorer, one can generated Entity Relationship (.mer) diagrams. This is well and good if you already have the tables (and relationships) constructed in the database. But it doesn’t help in the design phase. Is there a way to create an ER diagram from scratch…much like a UML diagram. Drag tables onto a form, add columns, specify column properties like primary key or unique, draw lines between columns to set up key constraints, etc?

I’m able to open up the .mer file in a text editor and edit it that way, buts its cumbersome to edit the xml by hand. Plus if its still linked to a database connection’s schema and you refresh it, poof, there goes your custom tables since they may not yet exist in the database.

[Brian Fernandes]

You aren’t missing anything, creating a schema from scratch using the ERD is a planned feature, but we haven’t committed it to a particular release yet.
The ERD for now is at best a viewer.

Thank you for asking, your request is noted.

Best,
Brian.

[Author]

Posts