This ability is limited to only VisioModeler 2.0 or later dictionary model (.imd) files and PLATINUM ERwin 2.6, 3.0, and 3.52. If you have an existing VisioModeler or PLATINUM ERwin model, you may be able to import it to create a Visio database model diagram. If you have not already associated the Visio database driver with a particular ODBC data source, click Setup. Select the database driver for your database management system (DBMS). On the first screen of the Reverse Engineer Wizard, do the following: If the wizard doesn't open: On the Database tab of the toolbar ribbon, in the Model group, select Reverse Engineer. The Reverse Engineer Wizard should open automatically. In the search results, double-click Database Model Diagram. In the Search box, enter database model and press Enter. This step ensures that the wizard maps the native data types correctly and that all the code that is extracted by the wizard is correctly displayed in the Code window. For more information about how to name a range of cells, see Define and use names in formulas.įor best results, set your default driver to the target database that you want to reverse engineer before you run the Reverse Engineer Wizard.
These ranges are treated like tables in the Reverse Engineer Wizard.
If you want to use more than one worksheet, just name the group of column cells in each worksheet. If you're going to reverse-engineer an Excel workbook, first open the workbook and name the group (or range) of cells that contains the column headings. If you have a database that you want to model so that you can understand it better or use it as a starting place for a new model, use the Reverse Engineer Wizard to extract the schema, or structure, of the database and build a new model.
0 kommentar(er)
