| Author |
getting a database model
|
Amy Phillips
Ranch Hand
Joined: Apr 02, 2003
Posts: 280
|
|
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
Joined: May 15, 2001
Posts: 35
|
|
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.
|
Laurent LEONARD
|
 |
Lasse Koskela
author
Sheriff
Joined: Jan 23, 2002
Posts: 11962
|
|
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"...
|
Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
|
 |
David Jordan
Author
Ranch Hand
Joined: Jun 14, 2003
Posts: 66
|
|
|
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)).
|
 |
 |
|
|
subject: getting a database model
|
|
|