FEBRUARY 12TH, 2009
By MOHAMMAD SAJJAD HOSSAIN

Reverse engineering MySQL database with Microsoft Visio

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.

mysql connector Reverse engineering MySQL database with Microsoft Visio

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.
  • Share/Bookmark

Related posts:

  1. Database models – DatabaseAnswers

Tags: , , ,

categories Database

13 Comments

  • By Arafat Rahman, February 12, 2009 @ 4:21 pm

    WOW! I was looking for this type of solution.
    Thanks a lot.

  • By Jilani Jidni, February 12, 2009 @ 5:24 pm

    Thanks for share with us. It will help me a lot.

  • By Milon, February 12, 2009 @ 7:03 pm

    Thank you Sajjad vai.

  • By Sammer, February 24, 2009 @ 12:51 pm

    Thanks a lot…Its helpful..
    i hva Mysql DB of nearly 100 Tables..
    so how to save it. with these diagrams.
    Also its showing me some primarky key errors pls help..

  • By Mohammad Sajjad Hossain, February 24, 2009 @ 2:08 pm

    Hi Sameer,
    I am sorry, but I have not understand “so how to save it. with these diagrams”. Please explain.

    Can you tell me what primary key error you are getting?

  • By giampaolo, February 27, 2009 @ 5:04 pm

    Thanks. It’s great

  • By jammula, July 15, 2009 @ 2:52 am

    hi tried installing the connector. i successfully connected to program in VS2008 but could’nt find system data source!!! can u help???

  • By Mohammad Sajjad Hossain, July 15, 2009 @ 2:59 pm

    Did you mean Visual Studio 2008 by VS2008? I have not used VS2008. Here I have shown how to reverse MySQL database with Microsoft Visio.

  • By garcon1986, November 6, 2009 @ 11:02 pm

    it works, thanks a lot.

  • By Mishant, February 28, 2010 @ 8:15 pm

    it works. thnx :) .

  • By Sotiris, March 30, 2010 @ 9:42 pm

    Good one. Thanks :)

  • By namita, May 29, 2010 @ 5:08 pm

    Hi,
    I followed the steps. It let me select the tables and all but after that it just keeps processing and hangs.
    Please help.

  • By techbrainless, July 6, 2010 @ 3:29 pm

    Hi … I have been stuck in the step 8 : # Select MySQL ODBC driver from the list.

    because i did not find such option …

    I am using visio 2003..

    techbrainless

Other Links to this Post

RSS feed for comments on this post.

Leave a comment

blog