Feb 27, 2007 Using the Reverse Engineer Wizard, I first select a database driver of 'Microsoft SQL Server'. For Data Source, is displays a few local ones, but since the is remote I select 'New'. Following the steps there, I enter and verify the data to connect to a remote data source.
With the Reverse Engineer Wizard in Visio Online Plan 2 and Visio 2019, you can create a database model from an existing database or a Microsoft Excel workbook. Database models graphically show the structure of a database so you can see how database elements, such as tables and views, relate to each other without showing the actual data. This can streamline creating a new database or understanding the structure of an existing one.
Subscription appVisio 2019Visio 2016-2013Visio 2010
The Database Model Diagram template lets you create a database model from an existing database. This template is available in the Visio app for those with Visio Online Plan 2 or a Visio 2019 license. If you're not sure what version of Visio you're using, click File > Account > About Visio.
Review what the Reverse Engineer Wizard extracts
The schema definition information that the wizard can extract depends on a combination of things, such as the capabilities of the database management system (DBMS) and ODBC driver. The wizard shows all the elements it can extract and lets you choose which ones you want. For example, you may be interested in only 5 out of 10 tables, and 2 out of 4 views.
While you are running the wizard you can choose to have it automatically create the drawing in addition to listing the reverse engineered items in the Tables and Views window. If you decide not to have the drawing created automatically, you can drag the items from the Tables and Views window onto your drawing page to manually assemble the database model.
To the extent that they are available from the target DBMS, you can extract the following:
Prepare to start the wizard
If you are reverse engineering an Excel workbook, before you start the wizard you need to open the workbook and name the group (or range) of cells that contain the column headings. If you want to use more than one worksheet, just name the group of column cells in each worksheet. These ranges are treated like tables in the wizard. For more information about how to name a range of cells, see the Microsoft Office Excel help.
For best results, set your default driver to the target database that you want to reverse engineer before you run the Reverse Engineer Wizard. This ensures that the wizard maps the native data types correctly and that all the code extracted by the wizard displays correctly in the Code window.
![]()
A vendor-supplied 32-bit ODBC driver must be from an ODBC Data Access Pack greater than version 2.0 and ODBC Level 1-compliant or greater. A vendor-supplied OLE DB provider must be compliant with the OLE DB version 1.0 or later specification.
Reverse engineer an existing database
If you use the ODBC Generic Driver, you may receive an error that indicates that the reverse engineered information may be incomplete. In most cases this isn't a problem — just click OK and continue with the wizard.
The wizard extracts the selected information and displays notes about the extraction process in the Output window.
The Database Model Diagram template lets you create a database model from an existing database. This template is available in the Visio app for those with Visio Online Plan 2 or a Visio 2019 license. If you're not sure what version of Visio you're using, click File > Account > About Visio.
Review what the Reverse Engineer Wizard extracts
The schema definition information that the wizard can extract depends on a combination of things, such as the capabilities of the database management system (DBMS) and ODBC driver. The wizard shows all the elements it can extract and lets you choose which ones you want. For example, you may be interested in only 5 out of 10 tables, and 2 out of 4 views.
While you are running the wizard you can choose to have it automatically create the drawing in addition to listing the reverse engineered items in the Tables and Views window. If you decide not to have the drawing created automatically, you can drag the items from the Tables and Views window onto your drawing page to manually assemble the database model.
To the extent that they are available from the target DBMS, you can extract the following:
Prepare to start the wizard
If you are reverse engineering an Excel workbook, before you start the wizard you need to open the workbook and name the group (or range) of cells that contain the column headings. If you want to use more than one worksheet, just name the group of column cells in each worksheet. These ranges are treated like tables in the wizard. For more information about how to name a range of cells, see the Microsoft Office Excel help.
For best results, set your default driver to the target database that you want to reverse engineer before you run the Reverse Engineer Wizard. This ensures that the wizard maps the native data types correctly and that all the code extracted by the wizard displays correctly in the Code window.
A vendor-supplied 32-bit ODBC driver must be from an ODBC Data Access Pack greater than version 2.0 and ODBC Level 1-compliant or greater. A vendor-supplied OLE DB provider must be compliant with the OLE DB version 1.0 or later specification.
Reverse engineer an existing database
If you use the ODBC Generic Driver, you may receive an error that indicates that the reverse engineered information may be incomplete. In most cases this isn't a problem — just click OK and continue with the wizard.
![]()
The wizard extracts the selected information and displays notes about the extraction process in the Output window.
Visio 2016 and 2013 don't support the Reverse Engineer Wizard
The Reverse Engineer Wizard isn't available in Visio Professional 2016, Visio Standard 2016, Visio Professional 2013, or Visio Standard 2013. In order to use the database modeling features, consider upgrading to Visio Online Plan 2.
In this articleReview what the Reverse Engineer Wizard extracts
The schema definition information that the wizard can extract depends on a combination of things, such as the capabilities of the database management system (DBMS) and ODBC driver. The wizard shows all the elements it can extract and lets you choose which ones you want. For example, you may be interested in only 5 out of 10 tables, and 2 out of 4 views.
While you are running the wizard you can choose to have it automatically create the drawing in addition to listing the reverse engineered items in the Tables and Views window. If you decide not to have the drawing created automatically, you can drag the items from the Tables and Views window onto your drawing page to manually assemble the database model.
To the extent that they are available from the target DBMS, you can extract the following:
Prepare to start the wizard
If you are reverse engineering an Excel workbook, before you start the wizard you need to open the workbook and name the group (or range) of cells that contain the column headings. If you want to use more than one worksheet, just name the group of column cells in each worksheet. These ranges are treated like tables in the wizard. For more information about how to name a range of cells, see the Microsoft Office Excel help.
For best results, set your default driver to the target database that you want to reverse engineer before you run the Reverse Engineer Wizard. This ensures that the wizard maps the native data types correctly and that all the code extracted by the wizard displays correctly in the Code window.
A vendor-supplied 32-bit ODBC driver must be from an ODBC Data Access Pack greater than version 2.0 and ODBC Level 1-compliant or greater. A vendor-supplied OLE DB provider must be compliant with the OLE DB version 1.0 or later specification.
Microsoft Visio Database Reverse Engineer CertificationReverse engineer an existing database
Microsoft Visio Database Reverse Engineering
If you use the ODBC Generic Driver, you may receive an error that indicates that the reverse engineered information may be incomplete. In most cases this isn't a problem — just click OK and continue with the wizard.
Microsoft Visio Database Reverse Engineering
The wizard extracts the selected information and displays notes about the extraction process in the Output window.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2021
Categories |