Reverse Engineer MySQL in VISIO 2007
Following are the steps to reverse engineer MySQL in VISIO 2007.
- Download and install MySQL ODBC driver 5.1 from MySQL website.
- Create System DSN for the MySQL Database using this driver
- Click on Reverse Engineer in Visio
- 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.
Try out the MySQL GUI tools… and particularly MySQL Workbench (although it’s still in beta). Will work better than Visio with MySQL.
uXuf
December 6, 2007 at 12:01 am
We can also import the database to MS SQL server and then reverse engineer easily if you find out any problem in above listed step.
Manish Pansiniya
March 11, 2008 at 6:53 am
Yes but some of those errors are failures to detect primary key fields!
Anonymous
April 30, 2008 at 4:51 pm
[...] are PC only. I generally work on a Mac but have my old PC as a backup. Anyway, it turns out that Visio has a reverse engineer feature. You need to open a new document with the Database ERD stencil and a menu option appears. It works [...]
Eric Fain » Blog Archive » Reverse Engineering a Data Model
May 5, 2008 at 6:26 pm
These directions were excellent. They saved me a lot of time from trying to figure it out for myself. Thanks.
Don Hames
June 23, 2008 at 12:40 am
Excellent, this worked great, thanks very much
Andy
September 16, 2008 at 9:49 pm
Thanks for your help. I was having no success with the old MySQL 3.51 ODBC driver, and I didn’t know a newer one was available.
Visio Pro 2007 still reports errors with identifying the primary keys, but then it goes ahead and draws the ERD correctly.
Conrad Halling
October 23, 2008 at 3:30 am
Hi there thanks for this. When I import it the text language shows up as Chinese!
Any ideas?
Thanks.
Bob G
November 11, 2008 at 11:17 pm
I am having the same problem..when I try and import, the table names that are detected are in chinese, and if i go head with the import, it gives me error, Can’t read dir of ‘.\w??????\’(errno:22)
Any thoughts?
rsiddiqi
November 24, 2008 at 11:14 am
ok.
tal cual
jairo
December 3, 2008 at 10:52 pm
perfect
amer
February 18, 2009 at 2:51 pm