ORM -> ER?

J

Jiho Han

This may be a stupid question that's been answered before but is there a way
to generate an ER diagram from ORM Source?
 
S

Scot Becker

Hi Jiho,
This may be a stupid question that's been answered before but is there a way
to generate an ER diagram from ORM Source?

It depends on what you mean and which version/stencil of Visio you are
using:

1) If you mean in general, yes. See Terry Halpin's book, Informational
Modeling and Relational Databases and his website, www.orm.net, for a
description of the R-Map algorithm for mapping tables from an ORM diagram.
2) If you are using Visio Pro, there is no automated way of mapping a
diagram created with the ORM Diagram stencil to an ER Diagram. You would
have to do it manually, as described in 1 above.
3) If you are using Visio for Enterprise Architects and have created a
diagram using the ORM Diagram stencil, then there is no automated way of
mapping it to an ER Diagram. You would have to do it manually, as described
in 1 above.
4) If you are using Visio for Enterprise Architects and have created a
diagram using the ORM Source Model stencil, then yes. Create a new diagram
from the Database Model Diagram Stencil, add the ORM Source model to the
project (Database | Project |Add Existing Document...), and then generate
the ER Model (Database | Project | Build).

Hope that helps,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top