Database Diagramming just plain doesn't work - What am I doing wro

[WhyDoIneedAHandle]

I reverse engineer the database from SQL 2005 it works great. Drag a dozen
or so tables to the page, it works great.

Go get a coffee. Drag another table onto the diagram. The Foriegn Key
relationships, which worked for the previous tables, do not appear for the
new table. I have not changed any settings, or options. It simply refuses
to read relationships from the model.

I start the diagram over. Everything works. This time when I drag and drop
the same table I get the Foriegn Key relationships. I move a few things
around, it stops working.

I move a table to make the diagram prettier. Columns in tables that were
there before, are gone. These are columns that are involved in foriegn key
relationships.

I attempt to refresh the model from the database to get the columns back.
It tells me that every single table is out of synch -- even though no tables
have changed.

I attempt to adjust a relationship connector. It disconnects from the table
and is now free floating. When I reconnect it to the table, the relationship
is wrong, and columns have been added to the table that were not there before.

I'm open to suggestions here, as I must be doing something completely wrong.

It seems like the table definition piece works, but the relationship piece
does not. I've scoured the options / settings dialogs and can't find any
option that would prevent it from placing existing relationships on the
diagram.

Suggestions?

 

[Barb Way]

I use SQL 2005 and reverse engineer from it pretty regularly without
problems. Can you give a bit more specifics on the workstation you are
using (OS, Visio version, service packs, etc.) ? Also, is this something
that was working until recently - and can you isolate what changed since it
used to work? If you open previously created database model diagrams and
work with them, do you see similar problems?


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
Thread-Topic: Database Diagramming just plain doesn't work - What am I
doing wro

I reverse engineer the database from SQL 2005 it works great. Drag a dozen
or so tables to the page, it works great.

Go get a coffee. Drag another table onto the diagram. The Foriegn Key
relationships, which worked for the previous tables, do not appear for the
new table. I have not changed any settings, or options. It simply
refuses
to read relationships from the model.

I start the diagram over. Everything works. This time when I drag and
drop
the same table I get the Foriegn Key relationships. I move a few things
around, it stops working.

I move a table to make the diagram prettier. Columns in tables that were
there before, are gone. These are columns that are involved in foriegn key
relationships.

I attempt to refresh the model from the database to get the columns back.
It tells me that every single table is out of synch -- even though no
tables
have changed.

I attempt to adjust a relationship connector. It disconnects from the
table
and is now free floating. When I reconnect it to the table, the
relationship
is wrong, and columns have been added to the table that were not there
before.

I'm open to suggestions here, as I must be doing something completely wrong.

It seems like the table definition piece works, but the relationship piece
does not. I've scoured the options / settings dialogs and can't find any
option that would prevent it from placing existing relationships on the
diagram.

Suggestions?