DB Diagram Doesn't Display Table Relationships

External Since: Mar 12, 2008 Posts: 1

I'm using Visio EA and reverse engineering a data model from SQL Server. I
step through the wizard and have Visio put the tables on the diagram.
Everthing works OK except it does not automatically create any relationships
between the tables.

The table PKs and FKs show up but no relationships. I was hoping it would do
this to save me time. I did a search and didn't find anyone else having this
problem. Does Visio EA automatically add the table relationships or is this
something that must be done manually?

TIA for any assistance.
--

Dianne Siebold [MSFT]

External Since: Feb 23, 2004 Posts: 2282

Dianne,
Have you checked this out?
http://msdn2.microsoft.com/en-us/library/aa140264.aspx
al

"Dianne Siebold [MSFT]" <DianneSieboldMSFT.TakeThisOut@discussions.microsoft.com> wrote
in message news:2ECA2FE6-43CC-48A2-B0FC-C18210D628B8@microsoft.com...
> I'm using Visio EA and reverse engineering a data model from SQL Server. I
> step through the wizard and have Visio put the tables on the diagram.
> Everthing works OK except it does not automatically create any
> relationships
> between the tables.
>
> The table PKs and FKs show up but no relationships. I was hoping it would
> do
> this to save me time. I did a search and didn't find anyone else having
> this
> problem. Does Visio EA automatically add the table relationships or is
> this
> something that must be done manually?
>
> TIA for any assistance.
> --
>
> Dianne Siebold [MSFT]