Friday, March 9, 2012

Diagram Editor

This is a rather weird one if anyone can help.
I create a new diagram on my machine through Enterprise Manager ver 8 then
go to another machine modify the diagram with EM ver 8 and save it. When I
re-open the diagram on my machine there are no tables in it.
Anyone know of any issues relating to this or anything.
Regards
Ian Frawley
Hi
I can't say I use the diagramming feature in EM that much as (IMO) it has
always been a bit functionally challenged!
Have you checked that the version of EM is the same on each machine i.e. the
tools have been patched to the same level? You may also want to try and see
that it has not been re-arranged so the tables are still there but off
screen.
John
"Ian Frawley" <yeah@.yeah.com> wrote in message
news:eJMrOlREGHA.3820@.TK2MSFTNGP12.phx.gbl...
> This is a rather weird one if anyone can help.
> I create a new diagram on my machine through Enterprise Manager ver 8 then
> go to another machine modify the diagram with EM ver 8 and save it. When I
> re-open the diagram on my machine there are no tables in it.
> Anyone know of any issues relating to this or anything.
> --
> Regards
> Ian Frawley
>
|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
Thanks for your response, I mainly use the diagram editor as a lazy way of
setting up relationships it has always worked well for me.
I checked EM and they all apear to be the same version (8) but I am unaware
if they have been patched in any way. In addition I tried zooming out, which
makes no difference and I even tried to re add tables and it doesn't allow
me to do this. Its all a bit odd TBH.

> Hi
> I can't say I use the diagramming feature in EM that much as (IMO) it has
> always been a bit functionally challenged!
> Have you checked that the version of EM is the same on each machine i.e.
> the tools have been patched to the same level? You may also want to try
> and see that it has not been re-arranged so the tables are still there but
> off screen.
> John
> "Ian Frawley" <yeah@.yeah.com> wrote in message
> news:eJMrOlREGHA.3820@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
As EM is a MMC there is no version number but you could check one of the exe
such as sqlmangr.exe, right click and check the version number. It does
sounds like the tables are still there if you can't re-add them.
With a bit of practice you may find it quicker to use Query Analyser and the
ALTER TABLE command than go through the process of adding tables and
creating FK constraints.
John
"Ian Frawley" <yeah@.yeah.com> wrote in message
news:%23lqLS6SEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> Thanks for your response, I mainly use the diagram editor as a lazy way of
> setting up relationships it has always worked well for me.
> I checked EM and they all apear to be the same version (8) but I am
> unaware if they have been patched in any way. In addition I tried zooming
> out, which makes no difference and I even tried to re add tables and it
> doesn't allow me to do this. Its all a bit odd TBH.
>
>

No comments:

Post a Comment