|
|
|
date: Fri, 20 Jun 2008 11:55:01 -0700,
group: microsoft.public.visio.database.modeling
back
RE: Reverse Engineering w/ Full Relations?
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs26 Visio does draw the relationships it finds in the Reverse Engineered database structure. Some databases may have related columns without having an actual Relationship defined, however. I have reverse engineered from some SQL 2000 databases where the structure was maintained through trigger code and other methods, and there were no Relationships to map out at all.
\par
\par As an overview - when you perform the Reverse Engineering wizard, the result will be (a) a list of Tables and Views, and Optionally (b) A visual representation of each table/view dropped on the drawing page, along with the defined relationships. In the default settings for the page, the Primary Keys and Foreign Keys will be bolded and have the appropriate letters (PK or FK) beside the column names. If nothing is defined as PK/FK, there are no relationships in the model.
\par
\par Do you see all of the tables that you expect when performing the Reverse Engineer function? Do you see columns that are marked as Primary Keys (pk) and Foreign Keys (fk) when you drop the tables onto the page? If you see a table which should have a Primary Key defined, can you go back into the original database manager and see the defined relationship, primary keys, etc.?
\par
\par What is the database server type / release that you are attempting to map in Visio? If you are reverse engineering from a SQL server, for instance, you might look at the database structure from the SQL tools to verify that there are actual Relationships defined. If you are able to, a good test would be to create a simple database with two tables that have one relationship between them, and see if you are able to bring the structure successfully into Visio.
\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 Thread-Topic: Reverse Engineering w/ Full Relations?
\par
\par If you browse to http://office.microsoft.com/en-us/visio/HA101154771033.aspx
\par and click on "Show me an example" (it should be visible w/o scrolling down),
\par the screenshot shows the arrow relationships that I'd like to have. But
\par reading through the tutorial, it seems like the only way to get those arrows
\par is to manually drag the Relationship stencil onto the page and connect two
\par tables together.
\par
\par It seems that a 2007 Visio should be intelligent enough to identify the
\par foreignkey relationships and lay out the relationship with arrows
\par automatically on reverse engineer. Is there a neat trick to this or is there
\par simply no light at the end of the tunnel? If there indeed is no light at the
\par end of the tunnel, perhaps someone can show me another tunnel that there
\par might be light :)
\par
\par Thanks,
\par
\par Minh
\par
\par "Minh" wrote:
\par
\par > I have Visio 2003 and also Visio 2007. I've successfully reverse
\par > engineered a database, but the diagram produced doesn't have any
\par > arrows that show the relationship between tables. Is there a way to
\par > reverse engineer WITH these arrow relations?
\par >
\par > Thanks you VERY MUCH!!!!
\par \pard
\par
\par }
date: Mon, 30 Jun 2008 20:36:26 GMT
author: (Barb Way)
|
|
