• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Diagramming and Documenting ... > Reverse Engineering an Existing Data...

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 items and dims other options. After you finish using the wizard, its status is displayed in the Output window and the extracted schema is displayed in the Tables And Views window, Code window, and the drawing page if you choose.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint