![]() Review your selections to verify that you are extracting the information you want, and then click Finish. 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. You can choose to have the wizard automatically create the drawing in addition to listing the reverse engineered items in the Tables and Views window. Select whether you want the reverse engineered items added automatically to the current page. If you selected the Stored Procedures check box in step 3, select the procedures that you want to extract, or click Select All to extract them all, and then click Next. If you are reverse engineering an Excel worksheet and don't see anything in this list, then it is likely that you need to name the range of cells that contain the column headings in your spreadsheet. Select the check boxes for the tables (and views, if any) that you want to extract, or click Select All to extract them all, and then click Next. Some items may be grayed out because not all systems support all the kinds of elements the wizard can extract. Select the check boxes for the type of information that you want to extract, and then click Next. If your data source isn't password protected, click OK. ![]() For example, in the Connect Data Source dialog box, type a user name and password, and then click OK. When you are satisfied with your settings, click Next.įollow the instructions in any driver-specific dialog boxes. When you create a new source, its name is added to the Data Sources list. If you have not already created a data source for the existing database, click New to do so now. Select the data source of the database you are updating. If you have not already associated the Visio database driver with a particular ODBC data source, click Setup to do so now. Select the Microsoft Visio database driver for your database management system (DBMS). On the first screen of the Reverse Engineer Wizard, do the following: ![]() In your database model diagram, on the Database tab, click Reverse Engineer. A vendor-supplied OLE DB provider must be compliant with the OLE DB version 1.0 or later specification. For example, if you are designing an Access database you would select the Microsoft Access Driver (*.mdb, *.accdb) check box.Ī 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. ![]() On the ODBC drivers tab, select the check box for the vender-supplied driver for your DBMA. If you are reverse engineering an Excel worksheet, choose the ODBC Generic Driver. For example, if you are designing an Access database you would choose Microsoft Access. On the Drivers tab select the Visio-supplied driver for your DBMS. On the Database tab, in the Manage group, click Database Drivers. 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.Ĭlick the File tab, click New, click Templates, click Software and Database, and then double-click Database Model Diagram. 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: 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. |