Manish Pansiniya's Blog

.NET, C#, Javascript, ASP.NET and lots more…:)

Reverse Engineer MySQL in VISIO 2007

with 15 comments

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.
About these ads

Written by Manish

November 24, 2007 at 12:30 pm

Posted in Uncategorized

15 Responses

Subscribe to comments with RSS.

  1. 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

  2. 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

  3. Yes but some of those errors are failures to detect primary key fields!

    Anonymous

    April 30, 2008 at 4:51 pm

  4. [...] 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 [...]

  5. 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

  6. Excellent, this worked great, thanks very much :)

    Andy

    September 16, 2008 at 9:49 pm

  7. 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

  8. 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

  9. 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

  10. ok.
    tal cual

    jairo

    December 3, 2008 at 10:52 pm

  11. perfect :-)

    amer

    February 18, 2009 at 2:51 pm

  12. pv

    November 28, 2009 at 5:58 am

  13. I just uploaded the ERD for liferay portal Data Base.
    Reverse engineered from MySql WorkBench.

    Here is the link.

    http://docs.google.com/fileview?id=0Bw2tQfFAGNE1NGIxYzBhYTgtOTc1NC00NTI2LTgxZGQtZGU1ZmE3MDhiYWI4&hl=en

    pv

    November 28, 2009 at 7:06 am

    • hi pv,

      where are the relation-connections ?

      u124

      September 30, 2010 at 8:02 am

  14. hey pv,
    how did u input data after creating the tables?

    Amy

    August 28, 2011 at 8:56 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: