This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getting a database model

 
Amy Phillips
Ranch Hand
Posts: 280
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
Is there a way I can get a full ERM model of my database when using mysql? I am used to working to access so have always been able to see what my databse looks like and would very much like to be able to continue this. Are there maybe applications which can create the view for me using my database?
Thanks
 
Laurent Leonard
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know if it works with mySql but Visio 2000 has a tool to make reverse engineering on db.
It works with Oracle.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Top-notch commercial products include among others:
*Sybase PowerBuilder
*Computer Associates ERwin

Haven't used them myself but have heard statements such as "why, oh why don't we have something like ERwin instead of sql*plus"...
 
David Jordan
Author
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Many of the JDO implementations provide a tool that will read your relational schema and then with some guidance from you generate a complete Java object model that essentially represents your data model as entities (classes) and relationships (using references (1) and collections (many)).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic