Reverse Engineering an Existing Database

Visio Professional 2007 makes it easy to extract information from a DBMS and add it to the drawing page. The Reverse Engineer Wizard walks you through the steps required to connect to a data source, specify a data source name (DSN), connect to a target database, and select the objects to extract from the database. Visio Professional 2007 can create a diagram automatically based on the objects you extracted, or you can create the diagram yourself. The wizard analyzes and validates the schema before adding it to the database model diagram in Visio Professional 2007.

The information that the wizard can extract depends on your target DBMS. If the DBMS doesn’t make all of the schema definition available, the ...

Get Microsoft® Office Visio® 2007 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.