Reverse Engineer Wizard

About this wizard

Steps you through the process of creating a connection to the target database you want to reverse engineer.

To create a connection, you specify an installed Visio driver and the 32-bit ODBC (Open Database Connectivity) data source. For convenience, before you run the wizard, you should set the default Visio driver and target database to the target database you want to reverse engineer.

The schema definition information that the wizard can extract depends upon a combination of things, such as the capabilities of the DBMS (Database Management System) and ODBC driver. To the extent that it is available from the target DBMS, you can select the schema definition information that the Reverse Engineer Wizard will extract.

Tables

Select this check box to extract tables from the target database.

Primary Keys

Select this check box to extract primary keys from the target database.

Indexes

Select this check box to extract indexes from the target database.

Foreign Keys

Select this check box to extract foreign keys from the target database.

Triggers

Select this check box to extract triggers, including trigger code, from the target database.

Check Clauses

Select this check box to extract check clauses, including check-clause code, from the target database.

Views

Select this check box to extract views from the target database.

Stored Procedures

Select this check box to extract stored procedures, including procedure code, from the target database.