The Reverse Engineering process brings all of the model information that is
available to the diagram, assuming that you selected all of the options in
setting it up. When you launch the wizard, you are first prompted to
select the database, then you should see a dialog prompting you to choose
the object types to reverse engineer. Be sure to include Primary Keys and
Foreign Keys when reverse engineering, or you will not have the information
needed to define the relationships.
Note that in some cases a database may not actually have Primary Keys and
Foreign Keys defined, which means that there are no actual relationships in
the schema. Sometimes designers create databases which maintain data
integrity through other means, such as trigger code and check clauses.
Anything other than a true PK-FK relationship will not be drawn in Visio.
Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
From: robo <
[email protected]>
Hi,
I'm using Professional Visio 2003 SP3. I've successfully reverse
engineered a database, but the diagram produced doesn't have any
arrows that show the relationship between tables. Is there a way to
reverse engineer WITH these arrow relations?
Thanks,
Robo
