ch1valrous.netlify.app

If you're just using Microsoft Visio to draw charts and diagrams, you're only scratching the surface of its features. Learn how to use Visio to perform data modeling and reverse engineering. Microsoft Visio has an option for reverse engineering. But by default it does not support MySQL or in other words you cannot reverse engineer a MySQL database. I have faced this problem and got the solution and sharing here with you.

Sometimes we need to reverse engineer our database. Microsoft Visio has an option for reverse engineering. But by default it does not support MySQL or in other words you cannot reverse engineer a MySQL database. I have faced this problem and got the solution and sharing here with you.

The steps involved in this process are described below:

1. Download the latest MySQL ODBC connector from MySQL site. You may find it here http://dev.mysql.com/downloads/connector/odbc/5.1.html.
2. After downloading install the connector.
3. Now open Microsoft Visio and open Database Model Diagram template (you may find it under Software and Database group).
4. From Database menu click on Reverse Engineer. You will see the Reverse Engineer wizard.
5. Click on the New button.
6. Select System Data Source.
7. Click Next.
8. Select MySQL ODBC driver from the list.
9. Click Next and then Finish. MySQL Connector/ODBC Data Source Configuration window will open.
10. Give a name to the datasouce, database server host, user name, password and select the database you want to reverse engineer. Remember, the list of database will be shown if you have provided correct information.
11. Click on Ok. Now you will find the data source in Data Source list.
12. Select the newly created data source and click Next. The regular wizard for reverse engineering will start.

Where is Reverse Engineer in Microsoft Visio 2010

Most people can not find Reverse Engineer in Microsoft Visio 2010, for ribbon interface is totally different from the classic style interface of Visio 2007 and Visio 2003. Fortunately, Classic Menu can bring your familiar classic menus and toolbar back to the new ribbon.

The Reverse Engineer can be easily found If you are using Classic Menu for Office...

Microsoft Visio Database Reverse Engineer Roles

1. On Menus tab, click File menu, and then click New from the drop-down menu.

2. It brings back to the New under the File tab. Please choose to select the Software and Database option from the Choose a Template panel.

3. After selecting Software and Database, double click Database Model Diagram from the scrolling dialogue box.

4. Then, it goes back to the ribbon interface of Visio 2010. On the Database tab, in the Model group, Reverse Engineer is at the leftmost corner next to Refresh.

5. Click Reverse Engineer, it will bring up the Reverse Engineer Wizard.

What is Classic Menu for Office?

Microsoft Visio Database Reverse Engineering

Classic Menu for Office 2010, 2013, 2016, 2019 and 365 is based on Micorsoft standard add-in technology, and designed for the users who are used to the interface of Office 2003/2002/2000. It shows the familiar classic menus and toolbars in Microsoft Office (includes Visio) 2010/2013, helps users get through the transition from 2003 to 2010, 2013, 2016, 2019 and 365, and saves money and time on training.

• All new features and commands of Visio 2010, 2013, 2016, 2019 and 365 have been added to the menus and toolbars;
• Without any training or tutorials after upgrading, users can work with Visio 2010/2013/2016 immediately.