J
JRough
I went through quite a bit of sacrifice to create tables in SQL Server
and then reverse engineer in Visio so I have all my tables and views
in the "table and views" window. Now I drag the table shapes onto the
diagram and am connecting the relationships. In some cases I
accidentally added the table twice. I notice to my horror if I delete
the extra one it deletes both of them. Why I do not understand. So I
just started dropping the duplicate table shape on the first one
because I could not figure out how to delete only one instance of my
table shape.
To make matters worse it deletes my underlying table!!!! That is
really bad! It is connected to SQL Server I guess that is what
reverse engineering does. So it is a live connection? I don't know
if it also dropped it from Sql Server?I'm not really sure what is
going on now since I didn't save the document so I could undo this.
NOw I have all my tables reverse engineered can you tell me how to
drop the live connection to SQL Server? I want all the tables that
were reverse engineered to stay in "Tables and Views" whether or not I
delete it from the diagram.
I noticed in Database/Options/Modeling I have the choice "always drop
from model",
"drop from model only if last occurence on diagram" or "never drop
from model". Which one I might or might not want is a mystery.
I am not sure what they mean by drop from "model" is that never drop
a table from my tables and views or from my diagram? I want to be
able to drag it back if I have deleted it and I want to be able to
delete a table shape without it going away from tables and views.
I am hoping you can help me since it took several days to reverse
engineer my database.
thanks,
and then reverse engineer in Visio so I have all my tables and views
in the "table and views" window. Now I drag the table shapes onto the
diagram and am connecting the relationships. In some cases I
accidentally added the table twice. I notice to my horror if I delete
the extra one it deletes both of them. Why I do not understand. So I
just started dropping the duplicate table shape on the first one
because I could not figure out how to delete only one instance of my
table shape.
To make matters worse it deletes my underlying table!!!! That is
really bad! It is connected to SQL Server I guess that is what
reverse engineering does. So it is a live connection? I don't know
if it also dropped it from Sql Server?I'm not really sure what is
going on now since I didn't save the document so I could undo this.
NOw I have all my tables reverse engineered can you tell me how to
drop the live connection to SQL Server? I want all the tables that
were reverse engineered to stay in "Tables and Views" whether or not I
delete it from the diagram.
I noticed in Database/Options/Modeling I have the choice "always drop
from model",
"drop from model only if last occurence on diagram" or "never drop
from model". Which one I might or might not want is a mystery.
I am not sure what they mean by drop from "model" is that never drop
a table from my tables and views or from my diagram? I want to be
able to drag it back if I have deleted it and I want to be able to
delete a table shape without it going away from tables and views.
I am hoping you can help me since it took several days to reverse
engineer my database.
thanks,