Database modeling with Microsoft Visio for an Existing MySQL Database

April 18th, 2010 by Usha Informatique Team Leave a reply »

In a SDLC, creating a database model diagram is an important step that needs to be taken to achieve the following

- Create a clear visualization of the Database for the system which makes the database understanding pretty easier

- It helps in derive out the classes required to be created by just looking into the database modeling diagram in depth

If you are not able to buy the paid tool for UML modeling such as rational rose etc., it’s still achievable through Microsoft Visio. Following are the steps that need to be performed to create a model diagram from an existing MySQL database in Microsoft Visio which is called as Reverse Engineering

- First of all, download the ODBC driver for MySQL from the location http://dev.mysql.com/downloads/connector/odbc/5.1.html. Download the installable by selecting the appropriate one based on  your machine configuration (32 bit or 64 bit)

- Install the mysql connector

- After installation, open visio

- Go to File->New->Database->Database Model

- From Database Menu, select Reverse Engineer

- On the Create New Datasource screen displayed, click on User Data Source

- Provide a datasource name

- Select the mysql connector driver, click on Next

- Click Finish and your new datasource would be added and would come as selected

- Click on Next

- Enter the valid username and password to create the connection using the datasource

- Select Object Type to reverse engineers

- You would be asked to select the database

- On selecting database, tables would be displayed

- Select the tables you want to create the datamodel for

- On selecting the tables, you would be asked to create the model with shape or without shape

- I select the shaped one and the model is generated

It’s really a helpful tool for the beginner to start creating the Database Modeling Diagram from an existing Database

Advertisement

89 comments

  1. wow very attractive sharing. thanks for this.

  2. Hello everyone thanks for good information.

  3. isolated site, when fall for due content, trail more visits. Your site is excelent.

  4. my girlfriend love your blog very much , she let me read this

  5. The internet have many blogs for visit, but your is one good blog, and I like came here very much.

  6. Thanks for thenice post. I really find it very communicative.it issupport for me . I would now go on this blog evermoreday!

  7. Wow this is a great resource.. I’m enjoying it.. good article

  8. Recently, I did not give whole lot thought to commenting on weblog articles and have left feedback even less. Viewing your useful piece of writing, might inspire me to do this again.

  9. You have a beneficial Blog right here Mate. Love your content really informative, Please preserve up the excellent work.

  10. I really like your blog and i respect your work. I’ll be a frequent visitor. How can I subscribe to RSS? Cartucce

  11. Hello webmaster, good day. Excellent blog post. You have gained a new fan. Pleasee continue this awesome work and I look forward to hear more of your superb posts.

  12. Do you possess several form of donation box where I may transmit monetary gift in PayPal? I would love to reward you for your contents. :)

  13. Mario Kanan says:

    I have been surfing online more than three hours today, yet I never found any interesting article like yours. It¡¯s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.

  14. Excellent read, I just passed this onto a colleague who was doing a little research on that. And he actually bought me lunch because I found it for him smile So let me rephrase that: Thanks for lunch!

  15. Incridible idea admin. You just help my homework for next examination Thanks admin

  16. This is the type of information that should be shared around the web. Shame on the search engines for not positioning this post higher!

  17. Thank you for Posting & I got to read nice information on your site.

  18. Great post – I’ve been struggling with this for some time and it’s great to see this information.

  19. I have look for such a article for a long time, thanks a lot.

  20. I was just browsing for relevant blog posts for my project research and I happened to stumble upon yours. Thanks for the excellent information!

  21. I really like your site and i really appreciate the excellent quality content you are posting here for free for your online readers. Can you tell us which blog platform you are using?

  22. What a good blog you have here. Please update it more often. This topics is my interest. Thank you. . .

  23. Hindi Sms says:

    I just love this info.

  24. home loan says:

    Of course, what a great site and informative posts, I will add backlink – bookmark this site? Regards, Reader.

  25. great information you write it very clean. I am very lucky to get this tips from you.

  26. I agree with you also it absolutely seeing help number of people.

  27. car cover says:

    Hello, I observed your webpage in a new directory of blogs. I dont know how your web page came up, should have been a typo, Your web website looks high high quality. Have a very good day.

  28. hi there, i just found your site on yahoo, and i would like to say that you write interestingly well via your web portal. i am truly impressed by the method that you write, and the subject is excellent. in any case, i would also like to acknowledge whether you would like to exchange links with my blog? i will be to the great extent than happy to reciprocate and put your link off in the link exchange area. waiting for your reply, i would like to convey my appreciation and gooday!

  29. Thanks for the sharing really usefull. I would like to bookmark this site.

  30. Cool post! How much stuff did you have to look up in order to write this one? I can tell you put some work in.

  31. I came across your site, i think your blog is awsome, keep working !

  32. Zella Bialas says:

    I love how you capture the essence of the concept, truly excellent writting manner, I enojoyed it!

  33. That is some inspirational stuff. Never knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here.

  34. good articles here hopefully i learned from it.

  35. I was just browsing for relevant blog posts for my project research and I happened to stumble upon yours. Thanks for the useful information!

  36. Advantageously, the post is in reality the freshest topic on curing acne naturally. I concur with your conclusions and will thirstily look forward to your upcoming updates. Just saying thanks will not just be enough, for the phenomenal clarity in your writing. I will right away grab your rss feed to stay abreast of any updates.

  37. Thank you very much this is a very nice information!. . . . . .

  38. Your post is very unique. Thanks for the information.

  39. Awesome post peter, it’s been a long-time since I’ve been on here. I see that nobody has lost their passion. Good to be back.