For more information about how to name a range of cells, see the Excel help.į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 wizard. If you want to use more than one worksheet, just name the group of column cells in each worksheet. 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. To the extent that they are available from the target DBMS, you can extract the following: 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. 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. For example, you may be interested in only 5 out of 10 tables, and 2 out of 4 views. The wizard shows all the elements it can extract and lets you choose which ones you want. 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. Review what the Reverse Engineer Wizard extracts If you're not sure what version of Visio you're using, click File > Account > About Visio. This template is available in the Visio app for those with Visio Plan 2 or a Visio 2019 license. The Database Model Diagram template lets you create a database model from an existing database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |