When you first open visio and go to File ->New->Getting Started-> Software and Database ->Database Model Diagram-> (from File Menu) Database-> Reverse Engineer you dont see any sign of mysql drivers.
Step 1: download the ODBC mysql driver!
Step 1.a: install
Now there are two ways of going about this one is through Visio (easiest).
Step 2 (via visio): Open Visio go to File ->New->Getting Started-> Software and Database ->Database Model Diagram-> (from File Menu) Database-> Reverse Engineer and then select ODBC Generic Driver under installed Visio Driver and click on "New ..." button underneath setup.
Step 3 (via visio): Select "User Data Source" and click on Next and then scroll down to select the "MySql ODBC 5.1/VERSION Driver" at the bottom as in the picture.
Step 4 (via visio): Click on Next and then it will say "When you click finish you will create the datasource you have just configured.The driver may prompt you for more information " click Finish.
Step 5 (via visio): When you click on finish it will prompt you for your database information. This is what my mysql db looks like :
The db name is letter4sure_development and the port is the default 3306 and then you just enter the user name and password so and try to "test" the connection :
As you can see the test connection was successful.
Step 6 (via visio): Now it should show up in your drop down so:
Step 7 (via visio): Now Visio should ask for the password again (and from here you should be able to handle this on your own but for completeness I will elaborate further):
It may give a warning about incompatible drivers (I ignored it).
Step 8 (via visio): You now select the primary keys, indexes and foreign keys you want imported. Step 9 (via visio): Now you select the tables (if you are using Ruby on Rails as I am do not select "schema info" since that table is used by the rake migrations table, remember!
Step 10 (via visio): Visio will ask if you want to add the shapes check "yes" and click next to see the following confirmation window (almost there):
Step 11 (via visio): View the generated schema and wish the author of this blog "Athar Shiraz Siddiqui" good will and blessings. Hopefully this was helpful for you...
Thursday, July 17, 2008
How To Reverse Engineer ER Diagram From MySQL in Visio
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
08
(10)
-
▼
Jul
(10)
- Ruby On Rails Quickly (hopefully)
- Journey to Ruby on Rails
- Writing Install Utility for JAMES: Java Apache Mai...
- How to Install JAMES :JAVA APACHE MAIL ENTERPRISE ...
- How To Import IXF Files into DB2
- How To Reverse Engineer ER Diagram From MySQL in V...
- Creating an Entity Relationship Diagram From MySQL DB
- How to Parse JAMES / SMTP Email Messages in Ruby
- How To Talk To JAMES administration from Ruby On R...
- iText with Ruby on Rails using Ruby Java Bridge
-
▼
Jul
(10)
Total Pageviews
Popular Posts
-
Early men used improvised devices to tell their position on the globe. Following is the Latitude Hook of the Polynesians . It is used to...
-
When you first open visio and go to File ->New->Getting Started-> Software and Database ->Database Model Diagram-> (from Fil...
-
How did early man attempt to discover the circumference of the earth without ever traveling it? This is how it was accomplished by a man ...
-
We hope this and all knowledge is used for the benefit of humankind : to encourage us towards love and kindness and goodness. Men have at...
-
How would one measure the height of a mountain if one only had a quadrant (for measuring angle)? A Quadrant A quadrant is as illustrate...
-
The question of how to tell longitude accurately was contested for a very long time. People had figured out how to tell latitude by use o...
-
I looked online and (in two books) but did not find very good explanations of ternary search trees. Following is what I combined together fr...
-
This was an easy one to do. I volunteered to help some people at the office and they mistakenly thought I was a "DB2 expert" despi...
-
(see discussion ) Step 1 : install JDK 1.5+ and above Step 2: check JAVA_HOME is set Step 3: install the rjb gem gem install rjb -v 1.1....
No comments:
Post a Comment