This is an awesome feature of MS visio that a lot of poeple don’t know. I use it mostly for documentation purpuses at the end of a development cycle.

1. Enable your MySQL to listen for network connections.
2. Allow privileges for your MySQL for the XP client to connect
3. Install the MySQL ODBC connector
http://www.mysql.com/products/connector/j/
4. Create the ODBC connector
On the windows machine:
Control Panel → Administrative Tools → Data Source (ODBC)
Click on System DSN, then click Add…
Choose MySQL ODBC 5.1 Driver

From there add the Data Source name, Can be anything you want.
Then add the server, user, pass & database info.

5. Open up Visio
6. File → New → Software and Database → Database Model Diagram
6. From the menu, select Database → Reverse Engineer
7. Select the Data Source name
8. Click Next >
9. Enter your password, and click OK
10. Select all tables or views you wish to reverse engineer

source: ubuntuforums

      

Related Posts

• Getting the domain name from a referer URL in mysql
• Monitoring MySQL and some offline query tools
• Connection to access or MS SQL database in ASP
• Creating a MySQL db and website backup at once
• Working with data from access database in asp.net