Copying objects between Database Diagrams and ER Source diagrams

[Dmitry Duginov]

Is it possible to cut-paste the tables with relationships between ER Source
Diagrams and Database Diagrams?
In 2005 for EA beta2 such an attempt causes GPF. Any suggested workarounds?
I need to split large Database Diagram into three ER Source Diagrams and
then combine them into a project.

 

[Scot Becker]

It is with VEA 2002 (I don't have the new beta).

Just a guess... Are any of the relationships you are pasting such that only
one end is connected to a table? If so, try pasting only relationships that
are connected on both ends.

Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog/Portal: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.

 

[Matt M]

It is with VEA 2002 (I don't have the new beta).

Visio EA 10.0.2705 here. If I try cutting and pasting tables between a
database model diagram and an ER source model I get the message:

"Paste and drag-and-drop of shapes between database model documents based on
different templates is not allowed"

In fact the pasted tables show up in the destination model, but as simple
shapes only, not model elements. They don't appear in the Tables and Views
window and have no database properties.

Matt M

 

[Scot Becker]

Sounds like one model an ER Source diagram and the other is a Database Model
Diagram. If so, make sure you are copying between the same types. Copying
from ER Source to ER Source and from DMD to DMD seems to work for me.

If the source is an ER Source Model and the destination has to be a Database
Model Diagram, create a new Database Model Diagram, add the source to it,
build the resulting model, and then you should be able to copy from the new
Database model Diagram to the target.

Scot.

 

[Dmitry Duginov]

Sounds like one model an ER Source diagram and the other is a Database Model
Diagram. If so, make sure you are copying between the same types. Copying
from ER Source to ER Source and from DMD to DMD seems to work for me.

If the source is an ER Source Model and the destination has to be a Database
Model Diagram, create a new Database Model Diagram, add the source to it,
build the resulting model, and then you should be able to copy from the new
Database model Diagram to the target.

I need it in reverse. I have a model that's too large and complex to be
presented at once and to be maintained by one person. So I wanted to split
it into several ER Source diagrams. It looks like there is no way to do this

 

[Scot Becker]

The only thing I can think of would be to generate the complete model as
DDL, implement it as a database, and reverse engineer the entire thing into
each source model. Then, delete what you don't want in each.

Scot.

 

[Scot Becker]

Similarly, you could export the model in ERX format and import it into each
source model. This would save you the hassle of creating the DB first.

Scot.

 

[Dmitry Duginov]

Similarly, you could export the model in ERX format and import it into each
source model. This would save you the hassle of creating the DB first.

Yeah, I thought of that but it's kinda weird to use 3rd party file format to
work with native diagrams, don't you think?