JRough View profile More options Jun 5, 3:32 pm Newsgroups: microsoft.public.visio.database.modeling From: JRough Date: Thu, 5 Jun 2008 15:32:32 -0700 (PDT) Local: Thurs, Jun 5 2008 3:32 pm Subject: can't delete table shapes from an ERD without loosing base tables Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author I have problem. When I have a duplicate table on my ERD diagram and go to delete one of them it deletes both of them and even worse it deletes the base table in "tables and views". I got all those tables from reverse engineering a SQL database and I don't want them to be deleted just because I delete a table shape from my diagram. I cannot figure out what the "options" would be to change it. The options don't make sense to me: *Always drop from model *drop from model only if last occurrence on diagram *never drop from model *ask user what to do I have chosen "never drop from model" but as I said if I happen to delete a table shape from my ERD then that base table in "tables and views" is gone forever. I just want to move it to a 2nd page. What is going on here? There are some other options: *Sync conceptual and physical names in new tables and columns when typing I'm not exactly sure what this does. I want all my tables from the SQL SErver datasource to stay in the "tables and views". Visio does not need to sync with SQL Server at this point since I already reverse engineered all the tables I wanted into Visio. If I uncheck this will it allow me to remove tables from the diagram and leave the tables in "tables and views" so I can add them to a 2nd page or move them around? If I uncheck will I just loose tia
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs26 See my response below for the question of the Model versus the shapes on the page. \par \par On the question of Syncing Conceptual and Physical names: This allows you to type one name, and force the other one to update automatically to match. I like this option, but many modelers prefer to keep their physical name formats completely separate from the conceptual ones, and we allow that by unchecking the Sync box. If you don't use Conceptual names, then keeping them synchronized is best. \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 \par JRough \par View profile \par \tab More options Jun 5, 3:32 pm \par Newsgroups: microsoft.public.visio.database.modeling \par From: JRough \par Date: Thu, 5 Jun 2008 15:32:32 -0700 (PDT) \par Local: Thurs, Jun 5 2008 3:32 pm \par Subject: can't delete table shapes from an ERD without loosing base \par tables \par Reply | Reply to author | Forward | Print | Individual message | Show \par original | Remove | Report this message | Find messages by this author \par I have problem. When I have a duplicate table on my ERD diagram and \par go to delete one of them it deletes both of them and even worse it \par deletes the base table in "tables and views". I got all those tables \par from reverse engineering a SQL database and I don't want them to be \par deleted just because I delete a table shape from my diagram. I cannot \par figure out what the "options" would be to change it. The options \par don't make sense to me: \par \par *Always drop from model \par *drop from model only if last occurrence on diagram \par *never drop from model \par *ask user what to do \par \par I have chosen "never drop from model" but as I said if I happen to \par delete a table shape from my ERD then that base table in "tables and \par views" is gone forever. I just want to move it to a 2nd page. What \par is going on here? \par \par There are some other options: \par *Sync conceptual and physical names in new tables and columns when \par typing \par \par I'm not exactly sure what this does. I want all my tables from the \par SQL SErver datasource to stay in the "tables and views". Visio does \par not need to sync with SQL Server at this point since I already reverse \par engineered all the tables I wanted into Visio. \par If I uncheck this will it allow me to remove tables from the diagram \par and leave the tables in "tables and views" so I can add them to a 2nd \par page or move them around? If I uncheck will I just loose \par tia \par \pard \par \par }
