|
|
|
date: Wed, 4 Jun 2008 16:29:34 -0700 (PDT),
group: microsoft.public.visio.database.modeling
back
RE: deleting an object table from diagram drops my underlying table
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs26 I prefer the setting "Ask User what to do", if you would like a prompt when you delete an entity from the page. That way I am always in control. If you prefer, you can set it to Never delete instead. Be aware that in the past, some users found that they could inadvertantly delete Tables and leave behind orphased Relationships by using that setting.
\par
\par The default in a fresh install is "Ask User", so that the accidental deletion you found does not occur. Visio has to maintain a Model of your database in the drawing, but you don't necessarily have to include each object on your drawing page(s). So the shape on the page is simply a copy of the object in the model - and the model contents are displayed in the Tables and Views window.
\par
\par If you have multiple copies of a Table entity on the page, and you do NOT delete it from the model on removing it from the page, then only the shape instance that you had selected should be removed from the drawing page, and the others should maintain their link to the master entity in the Tables and Views section.
\par
\par As to what happens on the server - the answer is nothing, unless you 'push' the change back to the server using Generate or Update Database, which are features found only in the Visio for Enterprise Architects version, not in Visio Pro. (VEA is a bundled version of Visio found only with Visual Studio Team editions).
\par
\par Barb Way
\par Product Support - Visio
\par Microsoft Corporation
\par [This posting is provided "As Is" with no warranties, and confers no rights.]
\par \pard\li720 --------------------
\par
\par I went through quite a bit of sacrifice to create tables in SQL Server
\par and then reverse engineer in Visio so I have all my tables and views
\par in the "table and views" window. Now I drag the table shapes onto the
\par diagram and am connecting the relationships. In some cases I
\par accidentally added the table twice. I notice to my horror if I delete
\par the extra one it deletes both of them. Why I do not understand. So I
\par just started dropping the duplicate table shape on the first one
\par because I could not figure out how to delete only one instance of my
\par table shape.
\par
\par To make matters worse it deletes my underlying table!!!! That is
\par really bad! It is connected to SQL Server I guess that is what
\par reverse engineering does. So it is a live connection? I don't know
\par if it also dropped it from Sql Server?I'm not really sure what is
\par going on now since I didn't save the document so I could undo this.
\par NOw I have all my tables reverse engineered can you tell me how to
\par drop the live connection to SQL Server? I want all the tables that
\par were reverse engineered to stay in "Tables and Views" whether or not I
\par delete it from the diagram.
\par
\par I noticed in Database/Options/Modeling I have the choice "always drop
\par from model",
\par "drop from model only if last occurence on diagram" or "never drop
\par from model". Which one I might or might not want is a mystery.
\par
\par I am not sure what they mean by drop from "model" is that never drop
\par a table from my tables and views or from my diagram? I want to be
\par able to drag it back if I have deleted it and I want to be able to
\par delete a table shape without it going away from tables and views.
\par I am hoping you can help me since it took several days to reverse
\par engineer my database.
\par thanks,
\par \pard
\par
\par }
date: Fri, 13 Jun 2008 00:35:57 GMT
author: (Barb Way)
|
|
