santhosh22s
Member
Hai can anyone suggest a good tool for generating ERD's for progress database..? I have tried for Pcase bt it didnt generate references..
Please help me out as early as possible.
Please help me out as early as possible.
Erd
- Thread starter santhosh22s
- Start date
http://www.tools4progress.com/pcase.html
Amendment... I Should read the question fully before posting!!!
How about...
http://atlantis.seidenberg.pace.edu/wiki/tabletpc/TabletERD
Amendment... I Should read the question fully before posting!!!
How about...
http://atlantis.seidenberg.pace.edu/wiki/tabletpc/TabletERD
tamhas
ProgressTalk.com Sponsor
There are a couple of options, but let me say up front that no tool is actually going to give you the relationships automatically because that information is not contained in the Progress schema. There are techniques for guessing, but that's the best they can do.
The premium commercial tool in this space is Enterprise Architect. It is full UML modeling, so a lot more than just an ERD diagram.
http://www.sparxsystems.com
On PSDN, you can download MDG technology for Enterprise Architect which will read a .df file to create the model. It also includes a "relationship guesser" based on shared field names. If you have a database like MFG/Pro, where the fields are prefixed with table identifiers, it won't find anything. If your schema has common audit trail fields in every table, every table will be falsely linked. So, YMMV
http://communities.progress.com/pcom/docs/DOC-43838
Finally, there is my own ABL2UML tool, which also works with Enterprise Architect. This reads the dictionary directly to build the model and has a more complete and robust profile than the MDG tools. This profile is suitable for legacy, procedural ABL code while the MDG stuff is oriented only toward OO code. There is currently no relationship guesser, although it would be easy enough to write one and customize it with things particular to your schema like stripping prefixes and ignoring certain common field names. What it does do, however, is to build links between the code components and the schema components so that you can see actual use. I.e., instead of just the theoretically possible joins, you see what actual joins are made and where.
http://www.oehive.org/ABL2UML
The premium commercial tool in this space is Enterprise Architect. It is full UML modeling, so a lot more than just an ERD diagram.
http://www.sparxsystems.com
On PSDN, you can download MDG technology for Enterprise Architect which will read a .df file to create the model. It also includes a "relationship guesser" based on shared field names. If you have a database like MFG/Pro, where the fields are prefixed with table identifiers, it won't find anything. If your schema has common audit trail fields in every table, every table will be falsely linked. So, YMMV
http://communities.progress.com/pcom/docs/DOC-43838
Finally, there is my own ABL2UML tool, which also works with Enterprise Architect. This reads the dictionary directly to build the model and has a more complete and robust profile than the MDG tools. This profile is suitable for legacy, procedural ABL code while the MDG stuff is oriented only toward OO code. There is currently no relationship guesser, although it would be easy enough to write one and customize it with things particular to your schema like stripping prefixes and ignoring certain common field names. What it does do, however, is to build links between the code components and the schema components so that you can see actual use. I.e., instead of just the theoretically possible joins, you see what actual joins are made and where.
http://www.oehive.org/ABL2UML
Similar threads
- Locked
- Doug Dunn
- Progress Blog