Reverse engineering MySQL database schema in Mircrosoft Visio 2007

Following are the steps to reverse engineer MySQL database schema in Microsoft Visio 2007.

• Download and install MySQL ODBC driver 5.1 from MySQL website.
• Create System DSN for the MySQL Database using this driver (Run odbcad32)
• Create a new document of type "Database Model Diagram"
  
• Click on Reverse Engineer in Visio under Database menu.
  
• Select the install Visio driver as ODBC Generic driver. Goto Setup and select MySQL ODBC driver 5.1
• Select your DSN as Data Source.
• Press next, it will give you some warning/error in conversion but at last when you press finish, it will reverse engineer the diagram

Ref: updated post from Manish Pansiniya’s Blog