Reverse Engineering an Existing Database

Visio Professional 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 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.

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 wizard displays options for the available ...

Get Microsoft® Office Visio® 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.