Menu
I have Visio 2016 professional installed, which by all my research should support database reverse engineering.
Every guide I find says to go to the Software and Database category and select "Database Model Diagram" for the Database tab to pop up with the option for reverse engineering.
I do not see this template in my list available, and the one's I've tried don't make the Database tab visible. Am I missing something from my list, or which one would allow this functionality? If I have one that supports the functionality, how would I enable it?
413
On the Data tab, click Link Data to Shapes. Select the ODBC option and select ODBC DSN. Select the DSN for SQL Server, select the table you want to import, and finish the wizard. This article uses Orders as an example.
We normally build a physical database from the ER diagram – this is called forward engineering. But there are times when you want to do the opposite – create diagram from existing database schema. This task is called reverse engineering, as you first have working tool and you create model from it.
Database reverse engineering is the process through which the logical and conceptual schemas of a legacy database, or of a set of files, are reconstructed from various information sources such as DDL code, data dictionary contents, database contents or the source code of application programs that use the database.
The database reverse engineering code was removed in Visio Professional 2016 because of some issues, but it was announced late last year that it will be returning this year. In the meantime, you may find my following blog useful : Creating a schema from Visio External Data Recordsets
137
The Visio Add-in for Database Modeling is available as a separate download for Visio Pro for Office 365 only.
The package is available for download here.
Info on system requirements, installation, and usage is here
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
