Select the types of objects that you want to reverse engineer. If an item is grayed out, that means there isn't any such element in the target database that you've selected.
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.
About this wizard
Important: Reverse engineering is supported for SQL Server 2016 and earlier versions. It is not supported for SQL Server 2019 or newer versions.
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.
